Match?, Lookup?

me0707 · Apr 9th, 2002, 06:42 AM

I have two sheets.
I need to know how to populate the first column in sheet 1 with the data in column T of sheet 2, based on a match of data in columns D, E, and F of sheet 1 with data in columns G, L, and M of sheet 2.

Asala42 · Apr 9th, 2002, 09:19 AM

Hiya,

You're likely looking for either a VLOOKUP or an INDEX/MATCH combo. I'm not sure I understood the specifics of your issue, but it sounds like your lookup would be based on 3 criteria (the 3 columns). If so, an easy approach might be to toss in new column holding the lookup criteria (for example: C2&D2&E2).

Hope that helps.
Adam

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 9th, 2002, 06:42 AM	#1
me0707 New Member Join Date: Apr 2002 Posts: 1	I have two sheets. I need to know how to populate the first column in sheet 1 with the data in column T of sheet 2, based on a match of data in columns D, E, and F of sheet 1 with data in columns G, L, and M of sheet 2.

Apr 9th, 2002, 09:19 AM	#2
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,027	Hiya, You're likely looking for either a VLOOKUP or an INDEX/MATCH combo. I'm not sure I understood the specifics of your issue, but it sounds like your lookup would be based on 3 criteria (the 3 columns). If so, an easy approach might be to toss in new column holding the lookup criteria (for example: C2&D2&E2). Hope that helps. Adam