Find matching data across two sheets

**macpegg** · 10-12-2011, 10:34 AM

Hi,

I'm a complete newbie..

I need a vlookup creating for if possible.

Sheet1 Column A has reference numbers that I need matching with the reference numbers on sheet 2 column A but I also want Sheet 2 column B to copy over with this matched data.

Hope this makes sense

Many thanks in advance

Darren

**NBVC** · 10-12-2011, 10:41 AM

Try VLOOKUP

e.g.

=VLOOKUP(A2,'Sheet1'!A:B,2,FALSE)

adjust sheetname and ranges/references to suit.

Then copy formula down.

**macpegg** · 10-12-2011, 10:45 AM

Originally Posted by NBVC

Try VLOOKUP

e.g.

=VLOOKUP(A2,'Sheet1'!A:B,2,FALSE)

adjust sheetname and ranges/references to suit.

Then copy formula down.

Thankyou.. Although all im getting is zeros?

Thanks

Darren

**NBVC** · 10-12-2011, 10:51 AM

Maybe the sheets are reversed?

=VLOOKUP(A2,'Sheet2'!A:B,2,FALSE)

**macpegg** · 10-12-2011, 10:51 AM

Originally Posted by NBVC

Try VLOOKUP

e.g.

=VLOOKUP(A2,'Sheet1'!A:B,2,FALSE)

adjust sheetname and ranges/references to suit.

Then copy formula down.

Actually I'm being dumb..

Thanks very much it works

**macpegg** · 10-16-2011, 08:07 AM

Another quicky one.. I hope... :-)

Once the Vlookup is complete.. Is there a way of copying the matched data to a column on the 1st sheet? next to the corresponding reference?

I would copy and paste but there is over 6800 lines..

Darren