Hi,
I have three sheets. Each sheet as a column with a unique ID. All three sheets will not have the same total number of IDs.
I need to match the ID in sheet 1 and 2, then take the data from sheet 2 and add it to the row in sheet 1. Then I need to do the same for sheet 3.
So sheet 1 is like this:
unique ID Data
1 x
2 d
3 ff
4 wff
5 sdfs
Sheet 2 is like this:
unique ID sheet2Data
3 aa
1 bb
4 cc
The end result I want is:
Sheet 1:
unique ID Data sheet2Data
1 x bb
2 d
3 ff aa
4 wff cc
5 sdfs
I have no idea how to do this.
thanks for any input.
Bookmarks