Hi,
I was wondering if I could get some help on how to combine data from multiple worksheets. Here is an example of what I am trying to accomplish:
Worksheet1 contains the following data:
<colgroup><col style="width:48pt" span="2" width="64"> </colgroup><tbody>
</tbody>
Worksheet2:
<colgroup><col style="width:48pt" span="2" width="64"> </colgroup><tbody>
</tbody>
I would like to grab the fruit data from Worksheet2 and add it to a new column in Worksheet1 for only the names specified in Worksheet1. Basically the logic I am trying to get at is, search through the Name column in Worksheet2 for the same names as in Worksheet1, then add the corresponding fruit values to Worksheet1. What kind of formula could I use for this?
Correct output should be:
<colgroup><col style="width:48pt" span="3" width="64"> </colgroup><tbody>
</tbody>
This is of course an extremely simplified example, the real data that I am using contains thousands of lines, but the idea is still the same. So my question is, what formula could I use for column C in Worksheet1 that can compare the name values in Worksheet1 with the name values in Worksheet2, and if they are the same, grab the fruit value corresponding to that name and add it to the column C? Any help would be greatly appreciated it.
Thank you,
Gavin
I was wondering if I could get some help on how to combine data from multiple worksheets. Here is an example of what I am trying to accomplish:
Worksheet1 contains the following data:
| Name | Colour |
| John | Blue |
| Kevin | Green |
| Anne | Red |
| Jen | Pink |
<colgroup><col style="width:48pt" span="2" width="64"> </colgroup><tbody>
</tbody>
Worksheet2:
| Name | Fruit |
| Jack | Apple |
| Kevin | Banana |
| Anne | Apple |
| Richard | Orange |
| Christine | Kiwi |
| Jen | Orange |
| John | Grapes |
<colgroup><col style="width:48pt" span="2" width="64"> </colgroup><tbody>
</tbody>
I would like to grab the fruit data from Worksheet2 and add it to a new column in Worksheet1 for only the names specified in Worksheet1. Basically the logic I am trying to get at is, search through the Name column in Worksheet2 for the same names as in Worksheet1, then add the corresponding fruit values to Worksheet1. What kind of formula could I use for this?
Correct output should be:
| Name | Colour | Fruit |
| John | Blue | Grapes |
| Kevin | Green | Banana |
| Anne | Red | Apple |
| Jen | Pink | Orange |
<colgroup><col style="width:48pt" span="3" width="64"> </colgroup><tbody>
</tbody>
This is of course an extremely simplified example, the real data that I am using contains thousands of lines, but the idea is still the same. So my question is, what formula could I use for column C in Worksheet1 that can compare the name values in Worksheet1 with the name values in Worksheet2, and if they are the same, grab the fruit value corresponding to that name and add it to the column C? Any help would be greatly appreciated it.
Thank you,
Gavin
Last edited:
