Vlookup for multi column

[Karnik]

Hello Expert,
Attempting to use "Vlookup" for multi columns, but I am getting error as #value !
Please see attached file ( Excel 2007)
Thanks in advance,
Karnik

[Fotis1991]

ARRAY formula in E2 and copy down.

=INDEX($N$2:$N$50,MATCH(A2&B2&C2&D2,$I$2:$I$50&$J$2:$J$50&$K$2:$K$50&$L$2:$L$50,0))

[Lemice]

Hello,

You can use this Array formula

Please Login or Register  to view this content.

In Cell E2, and drag it down. When you enter it, hold Ctrl-Shift then hit Enter.
I know, it doesn't look elegant at all.
I'll try if I don't have to add them manually ...

Edit: Fotis, you beat me to it!

[Lemice]

Here is another solution

Please Login or Register  to view this content.

Similarly, this is an Array Formula

[Fotis1991]

@ Lemice

I welcome a good Exceller!