Vlookup array

[Devender Kumar Yadav]

I have required some data by vlookup array.
Problem is two column is in left side of lookup value column and two or more column is in right of lookup value column.

Please suggest the combination formula for left & right value by vlookup array.

 

[p45cal]

Using INDEX MATCH For Advanced Lookups | Deskbright
https://www.deskbright.com/excel/using-index-match/
Excel INDEX / MATCH function instead of VLOOKUP – formula examples
https://www.ablebits.com/office-addins-blog/2014/08/13/excel-index-match-function-vlookup/

 

[pecoflyer]

Left VLOOKUPS https://www.thoughtco.com/excel-left-lookup-formula-using-vlookup-3124101
First search the Net before posting