look up multiple fields
 

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!!!!!!!!
--
Maritza

look up multiple fields
 

=Index(Sheet1!A:A,Match(B2&C2&D2,Sheet1!$B$1:$B$10 00&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.

--
Regards,
Tom Ogilvy



"Maritza" wrote:

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!!!!!!!!
--
Maritza

look up multiple fields
 

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

On Aug 9, 2:58 pm, Maritza wrote:
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!!!!!!!!
--
Maritza

look up multiple fields
 

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

On Aug 9, 2:58 pm, Maritza wrote:
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!!!!!!!!
--
Maritza