look up multiple fields

[Guest]

Hello smart people!
I need to update a worksheet to include data from an older worksheet.
Columns ABCDE have data. I need to populate columns FGHIJ with data if BCD
match between sheets. Can I do that with a VLookup? or Index?

Thanks!!!!!!!!

 

[Guest]

=Index(Sheet1!A:A,Match(B2&C2&D2,Sheet1!$B$1:$B$1000&Sheet1!
$C$1:$C$1000&Sheet1!$D$1:$D$1000,0),1)

entered with Ctrl+shift+Enter rather than just enter since this is an array
formula

Adapt for other columns.

Drag fill down the column.

 

[KLZA]

You could do something like this in say cell F...

=IF(B1='Old Sheet'!B1,"MATCH","NO MATCH")

Then follow with this

=IF(F1="MATCH",B1,"NO MATCH")

Play around with this simple logic and it should do the trick for
you...

 

[KLZA]

Or you could do this...

=IF(B1='Old Sheet'!B1,'Old Sheet'!B1,"NO MATCH")

So you'll only see data from the old sheet if you find a match,
otherwise, it will say no match..