Capture Data on Another Sheet

**Andrew.Trevayne** · 06-17-2011, 03:21 AM

Hello again,
Just need help on VLOOKUP (I think).
What I am trying to do is to populate a column (on sheet1) with data taken from sheet2 if there is a match.
On my DUmmyExcelSheet Attached:

I have Column A, B, C and D on Excel Sheet 1
I have column A, B and C on Excel Sheet 2

What I need is when I Put Data on Column D Sheet1,
It will look for a match in column A Sheet2. If there's a match, it will copy the data from Column B and C Sheet 2 and paste it on Column B and C of Sheet 1.

I hope I made sense ^^

I'm sure this is easy but I'm a dummy with Excel. Hope somebody could find time to take a look. Thanks in advance.

**brokenbiscuits** · 06-17-2011, 03:39 AM

You can use:

=VLOOKUP(Sheet1!$D2,Sheet2!$A:$C,2,FALSE)
for column B and
=VLOOKUP(Sheet1!$D2,Sheet2!$A:$C,3,FALSE)
for column C

Alternatively, you could use
=VLOOKUP(Sheet1!$D2,Sheet2!$A:$C,column(),FALSE)
but this requires the information you're looking for to be in the same column on both sheets - which in this case works, but may not with your actual data.