I was hoping that someone could help me with a formula that would match ID numbers with the names of staff.
Have two spreadsheets; one with the staff and their ID numbers and the other where I type the id number of the staff in B column and would like A column to match the name from the other spreadsheet.
MacBook Air, macOS Sierra (10.12.1)
Assuming you have two tables in the same document then you can do a lookup with something like this:
The formula in A2 of Table 2:
=INDEX(Table 1::A,MATCH(B2,Table 1::B,0))
The MATCH looks at the ID in column B of Table 2 and finds what row number it appears on in 'Table 1'. That row number is passed to the INDEX function, which looks up the corresponding value in column A of 'Table 1'.
SG
Thank you so much, this has really helped
AD
How to match ID numbers with names in numbers
