Looking for lookup formula that will copy and populate another sheet

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....

Hi
Use this in Sheet1!J2 and drag down and forward

Formula:

Please Login or Register  to view this content.

Hi AliGW, thanks.

I'm using Excel 2016....

Thanks Jose, appreciated...

Thanks beebo021999

Originally Posted by bebo021999

How about in A2:

Please Login or Register  to view this content.

Drag down and accross

Done, thanks...

Originally Posted by AliGW

Then please update your forum profile, which currently says Excel 2010. Thanks.