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, 11 views)