Robert Priest
Robert Priest

Reputation: 11

find and replace in google sheets

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

Answers (2)

sigur7
sigur7

Reputation: 936

QUERY could be used here. Try:

=QUERY(Persons!A2:ZZ, "SELECT B WHERE A = J)

Upvotes: 1

Robert Priest
Robert Priest

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

Related Questions