Populating fields in 2nd spreadsheet from another spreadsheet

**Cirro** · 11-13-2012, 08:18 AM

Hi. Please see simple example below.

Col 1 Col 2

Roger British
Sharon French
Emily Canadian

In the second sheet I want to type 'Roger' and in another cell I need the formula which returns 'British'. What is my formula please? I seem to be struggling with IF for this job.
Thanks

**benishiryo** · 11-13-2012, 08:34 AM

hi Cirro, welcome to the forum. assuming your data is in Sheet1, A1:B3, & "Roger is in A1 of Sheet2, try this in Sheet2:
=VLOOKUP(A1,Sheet1!$A$1:$B$3,2,0)

**Cirro** · 11-13-2012, 08:49 AM

Originally Posted by benishiryo

hi Cirro, welcome to the forum. assuming your data is in Sheet1, A1:B3, & "Roger is in A1 of Sheet2, try this in Sheet2:
=VLOOKUP(A1,Sheet1!$A$1:$B$3,2,0)

Perfect. Thanks. Sorry it was so simple!

**K m** · 11-13-2012, 08:38 AM

Assumptions:
- Your table, Roger British, etc. are in Cells A1 and B1 of Sheet1
- Your Query is in Cell A1 of Sheet2
Use this formula
=VLOOKUP(A1,Sheet1!A1:B3,2)

The formula says look at Cell A1 of this worksheet. Now look at Array(Range) A1:B2 of Sheet1. If there is a match, return what is in column 2 in the corresponding row in Sheet1.

Hope that helps