just wondering, is there a formula that will display the cell that excel thinks matches the lookup criteria?
specific case:
my vlookup is for a column of data, and one of the cells within the lookup column is actually a blank cell. Within the lookup range, there are no blank cells, but I am still getting a result.
My suspcision is that it is returning based on one of the cells within the range being the number zero (0), so therefore (empty cell) = 'zero' in excel's eyes, but I would like a formula to confirm this suspicion 100%.
Bookmarks