VBA code 3 way lookup replace the old value by new value from masterdata
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
|