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
<tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
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>