Vlookup for two lookup values

[vaibhav2312]

Dear Friends

i want a vlookup formula or match with two lookup value i.e.

Sheet2 A2&B2 lookup values & sheet1 table arrey (A:E) data should be copied of column E

See attached workbook for further information.

[Ace_XL]

Use this array formula..

=INDEX(Sheet1!$E$2:$E$9,MATCH(A2&B2,Sheet1!$A$2:$A$9&Sheet1!$B$2:$B$9,0))

Confirm with Ctrl+Shift+Enter and not just Enter

[vaibhav2312]

Wow

Working Perfect Awesome

Thanks you very much

Reputation Added

[martindwilson]

non array
=INDEX(Sheet1!$E$2:$E$9,MATCH(A2&B2,index(Sheet1!$A$2:$A$9&Sheet1!$B$2:$B$9,0),0)

[vaibhav2312]

simply Awesome
Thank you