I have an excel chart where Column A has numbers from 1 to 100 and column B has people's names.
On another tab (sheet 2), I have created a spreadsheet where I will enter people's names and I want their corresponding ID numbers (from column A, sheet 1) to be displayed on a column beside the names.
This is the function I'm using:
IF(ISERROR(MATCH(B10,Sheet1!B:B, 0)), "No Match", INDIRECT(ADDRESS(MATCH(B10,Sheet1!B:B, 0),Sheet1!A:A)))))
and I can't figure out why I'm not getting anywhere. Anyone can point me towards the right direction?
Any and all helps are much appreciated.
Thanks!
Bookmarks