Index/Match formula

[jsp33]

I am trying to pull data from one worksheet into another worksheet. I think using Index/Match is the way to go, but I'm not sure how (I tried Vlookup and don't think that's the right formula).

Worksheet one has numbers in column A (say 1 to 10), and in Column C has the data (Town visited) I want to pull in to worksheet two. Worksheet 2 has the SAME numbers, with names associated with the numbers, and so on occasion there may be 2 or 4 number 4's with different names. I want to use the numbers in column A of both worksheets to grab the Town and match it up with the name. So in the second worksheet, I want everything that has a 1 to have 'Chicago' next to it, and everything that has a 2 to have 'New York', etc. See below for an example

1	Tuesday	Chicago
2	Wednesday	New York
3	Tuesday	Atlanta
4	Friday	San Francisco
5	Saturday	Austin
	WORKSHEET 1

<tbody>
</tbody>

WORKSHEET 2
1	Jane Smith
1	John Smith
1	Sam Smith
2	Steve Jones
3	Allen Stevens

<tbody>
</tbody>

	ANSWER I'M LOOKING FOR
1	Jane Smith	Chicago
1	John Smith	Chicago
1	Sam Smith	Chicago
2	Steve Jones	New York

<tbody>
</tbody>

 

[Eric W]

Try, assuming both your sheets start in row 1:

=VLOOKUP(A1,Sheet1!$A$1:$C$100,3,0)

If you have headers, change the 1s in the formula accordingly.

 

[kweaver]

Try this:

Excel 2010
	A	B	C
1	1	Jane Smith	Chicago
2	1	John Smith	Chicago
3	1	Sam Smith	Chicago
4	2	Steve Jones	New York
5	3	Allen Stevens	Atlanta
PeopleCities

Cell Formulas
Range	Formula
C1	=VLOOKUP(A1,Cities!$A$1:$C$5,3,FALSE)

 

[jsp33]

Try, assuming both your sheets start in row 1:

=VLOOKUP(A1,Sheet1!$A$1:$C$100,3,0)

If you have headers, change the 1s in the formula accordingly.

Thank you, that worked. I tried a Vlookup and it did not work, not sure what I did wrong!

 

[Eric W]

The functions can be finicky, if you put a comma or a zero in the wrong place, it won't work.

Glad we could help!