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

		Microsoft Office Forums > Microsoft Excel > Excel
VBA code 3 way lookup replace the old value by new value from masterdata

10-09-2015, 07:26 PM

macropod

Windows 7 64bit VBA code 3 way lookup replace the old value by new value from masterdata

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

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]

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to search with column heading then doing the lookup action for below code	cmreddy.vba	Excel Programming	0	01-20-2015 03:44 AM
Search and replace/insert HTML code into Master File using tags	dave8555	Excel	2	02-23-2014 03:51 PM
Lookup	angie.chang	Excel	1	07-27-2012 09:45 PM
Possible Lookup	Karen222	Excel	3	01-10-2012 05:41 AM
LookUp	aztiguen24	Excel	5	05-24-2011 03:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:23 PM.