See if this gets you pointed in the right direction:

With your data in cells A1:D9, including column titles.

F1: 10
G1: KGW
H1: Head Lamp
I1: Supra
J1: =INDEX($D$1:$D$9,MATCH(G1&H1&I1,$A$1:$A$9&$B$1:$B$ 9&$C$1:$C$9,0))

The ARRAY FORMULA* formula in J1 concatenates the lookup parameters and
searches for them in the concatenated lookup table columns.

An alternative, approach would be to insert a column in front of the
table (in Col_A, moving the table to the right) and concatenate the
fields there.

Example:
A1: B1&C1&D1

Then the formulas could be this:
F1: 10
G1: KGW
H1: Head Lamp
I1: Supra
J1: =VLOOKUP(G1&H1&I1,$A$1:$E$9,5,0))

Note: If there is no match, the Col_J formulas would return an error.
To avoid that, the new formulas would be:

J1 (ARRAY FORMULA*):
=IF(ISNA(INDEX($D$1:$D$9,MATCH(G1&H1&I1,$A$1:$A$9& $B$1:$B$9&$C$1:$C$9,0))),"",INDEX($D$1:$D$9,MATCH( G1&H1&I1,$A$1:$A$9&$B$1:$B$9&$C$1:$C$9,0)))

or
If using thelookup values in Col_A:
J1:
=IF(ISNA(VLOOKUP(H1&I1&J1,$A$1:$E$9,5,0)),"",VLOOK UP(H1&I1&J1,$A$1:$E$9,5,0))

*Note: For array formulas, hold down [Ctrl] and [Shift] when you press
[Enter], instead of just pressing [Enter].

Does that give you something to work with?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=544797