• The forum (and all other resources in Chandoo.org) will be under maintenance and will be unavailable for a maximum of two hours on the first week of October 2023. The exact date, time and duration of the maintenance are subject to change. We regret the inconvience it may cause.
  • Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VLOOKUP to return result based on formula


New Member
Sorry, vague title, I wasn't sure how to phrase it!
So essentially I want a VLOOKUP up entered into column AB in the Oracle tab.
I want it to look up cell T2 from the mapping tab in columns K - M and bring back column M

The issue!
Col K has duplicates which need to stay and obviously a VLOOKUP will return the first instance of the result, some rows have blank cells in M when column R is "No" I basically want the VLOOKUP to ignore all these blank cells and return the result for the next match.

Help would be greatly apprecaited!


  • Chandoo Template.xlsx
    223.1 KB · Views: 4
what version of excel do you have - maybe able to use a filter to return what you are after - but thats a 365 version option, and i also think was available in version 2019