dear experts

i have set of data need to compare with first 3 way lookup result with child series and description.



lookup value is COUNTRY and DSERIAL and GCOA PARENT result should be match with masterdata file

if not match replace by new value.

for e.g COUNTRY = Luxembourg
DSERIAL = 10004
GCOA PARENT = P10000 RESULT SHOULD BE FOR THE MATCHING 100640

find the attachment

Attached Files

cgi.xlsx (318.4 KB, 9 views)

In C2 of Sheet 2, input:
as an array formula (Ctrl-Shift-Enter) and copy down as far as needed.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Cross-posted at:
http://www.excelforum.com/excel-prog...ml#post4209256
and:
http://www.mrexcel.com/forum/excel-q...ml#post4347882
and:
http://www.excelguru.ca/forums/showt...rom-masterdata

For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184

Thread closed.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]