I am doing a vlookup. The file I am pulling from either has the item, doesn't have the item or is blank.
if it does have the item and is blank, I want it to come back blank.
If it doesn't haven't the item, I want it to come back blank.
What I am pulling into
c3 d3
Pull in
b5 xyz 5
b6 abc blank
b7 lmn blank
What I am pulling from:
c3 d3
B13 xyz 5
B14 abc
B15 qrs 5
Bookmarks