Hi,
Hoping you could help on the formula.
I'm trying to lookup a value (Sheet1 Column A) in a list of number in Sheet2 Column A and if found it returns "Yes", if not "No". Another condition is that if the cell in the lookupvalue is blank, the result will be blank.
Result to be shown in Sheet1 Column B
I have attached a sample of the work I'm doing
Many thanks in advance.
Bookmarks