vlookup same value multiple rows

[pmeghnathi]

I look E column value by vlookp find colomn A to B but result F column same.

 

[alansidman]

If you are using XL2010 or later, you could do a join on the two tables using Power Query.
If you are still using earlier versions, then here is a link to a workbook with a UDF created by kvsrinivasamurthy

MLOOKUP.xlsm | Powered by Box

app.box.com

 

[pmeghnathi]

If you are using XL2010 or later, you could do a join on the two tables using Power Query.
If you are still using earlier versions, then here is a link to a workbook with a UDF created by kvsrinivasamurthy

MLOOKUP.xlsm | Powered by Box

app.box.com

I use Excel 2003 please sir formula clea hear

 

[pmeghnathi]

I use Excel 2003 please sir formula clea hear

I not want all results in one cell
I want particular cell opp value

 

[alansidman]

I can only provide you with a horizontal solution. If that does not work for you, then you will have to wait for someone else to respond. Good Luck

MultiLookup.xlsx | Powered by Box

app.box.com

 

[pmeghnathi]

I can only provide you with a horizontal solution. If that does not work for you, then you will have to wait for someone else to respond. Good Luck

MultiLookup.xlsx | Powered by Box

app.box.com

Thanks sir I waiting

 

[pmeghnathi]

How to return multiple matching values based on one or multiple criteria in Excel?

 

[pmeghnathi]

How to return multiple matching values based on one or multiple criteria in Excel?View attachment 110602​

Please help