• 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