VBA code 3 way lookup replace the old value by new value from masterdata

[manilara]

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

 

[Myconservator]

Can't you add a column to concatenate these 3 fields and use it as index?

 

[Macropod]

Cross-posted at:
VBA code 3 way lookup replace the old value by new value from masterdata
and
VBA code 3 way lookup replace the old value by new value from masterdata
and:
http://www.excelguru.ca/forums/show...ce-the-old-value-by-new-value-from-masterdata

Please read our policy on Cross-Posting in rule #10: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html