Hi,
Hope you are all good.
I'm looking for some assistance re a task I'm doing in relation to a data correction exercise.
I have a workbook that contains 2 sheets, the first sheet is my destination and where I'd like my results to be written, the other sheet is my source.
Both sheets have unique references and are my primary source, re a lookup.
This is what I'd like to achieve:
Sheet 1 has 9 columns, the first three are blank, the others contain new property details and the unique references.
Sheet 2 has four columns, the first being the unique reference and the balance being name details.
I'd like a formula that looks up the unique reference in sheet 1, matches that with the unique reference in sheet 2 and populates columns A,B & C of sheet 1, with the contents of columns B,C & D from sheet 2.
Sheet one will have about 270 rows that have been identified as corrections and sheet 2 the source has about 4000 rows to search from.
To assist, I've attached an example, thanks....
Bookmarks