Thread: VBA code 3 way lookup replace the old value by new value from masterdata
View Single Post
 
Old 10-09-2015, 07:26 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,363
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
In C2 of Sheet 2, input:
Code:
=INDEX(masterdata!D:D,MATCH(C2&E2,masterdata!C:C&masterdata!E:E,0))
as an array formula (Ctrl-Shift-Enter) and copy down as far as needed.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]