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