Using ISERROR, Match and Address functions

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!

Try it this way:

=IF(ISERROR(MATCH(B10,Sheet1!B:B,0)),"No Match",INDEX(Sheet1!A:A,MATCH(B10,Sheet1!B:B,0)))

This assumes that your names are in column B of Sheet2, and that the formula is put into row 10 (e.g. in A10, or C10), and it can then be copied down.

Hope this helps.

Pete

Thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Pete