Look Up and Show result

[Chantal4130]

Hi all

I am trying to look up Data based on 2 columns.

I tried using a VLOOKUP but I can only do this with looking up 1 column.

Attached you will see a sheet called 'List' using the Data in Column D and E I want to find and match it in Sheet name 'Lookup' in the columns E and F
And then return the result(the Price) that's in Column G and display it against the correct match in Sheet 'List' in column F

Any help would be much appreciated

Thanks

[mangesh.mehendale]

Hiii the best solution to multiple criteria for Vlookup is helper column... Please see in attached sheet

[Chantal4130]

Hi Mangesh

This is perfect - Thanks So Much!!!

I have added to your reputation

[shukla.ankur281190]

You can do this thing without helper column

List sheet F2 =IFERROR(INDEX(Lookup!$G$2:$G$38,MATCH(List!D2&List!E2,INDEX(Lookup!$E$2:$E$38&Lookup!$F$2:$F$38,),0)),"") drag down.

[mangesh.mehendale]

Ankurji, It is not showing result i.e. $2.00 at F2.....

[shukla.ankur281190]

Hi Mangesh,

I am sure you are trying may given formula in your file which is uploaded by you here in #2. You have created a helper column there in your file, So it will take your helper column you can test my formula on post #1 file once

[mangesh.mehendale]

Yes you are correct.. thanks I will study your formula...