Reputation: 11
I have two sheets in the one spreadsheet 'Stats' and 'People' (this is a complete list of every person with their id number). I am trying to add the person's number into 'Col A' from a matching record in the 'persons' sheet.
Below is the snippet of the two sheets.
'Stats' tab
Col A = (needing the person ID number here from the 'Col B' in the 'persons' sheet)
Col J = Persons Name
'Persons' tab
Col A = Persons Name
Col B = Persons ID
Upvotes: 0
Views: 71
Reputation: 936
QUERY could be used here. Try:
=QUERY(Persons!A2:ZZ, "SELECT B WHERE A = J)
Upvotes: 1
Reputation: 11
Answer if you in the forth row
=VLOOKUP(J4,people!A:B,2,FALSE)
'J4' = is the ColJ with the person name
'J4,people!A:B' = is the range to search
'2' = is the second col to display
'false' = honesty no idea it works.
Upvotes: 1