• 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!



Active Member
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