Index and Match or Vlookup or.....

[Dan Hollingworth]

Hello all,

New to the site, I've used the site a lot over the years but never posted, so this must mean I'm stuck, and would appreciate your help! So here goes...

I'm not sure what function I need to use to get the required outcome, some sources I read say Index and Match would be the one, but others have also been suggested.

My issue relates to the below:

I want to insert a function into cell C2 that will automatically select the correct value from the table on the right when I enter data into the cells in A2 and B2. For example the data I have entered in cells A2 and B2 should target cell G6 and display its value in C2.

I don't know if this can be done because of the way the table is set out, obviously the weights are ranges and I just don't know how to make it work.

Any advice would be greatly appreciated

Cheers

Dan

 

[NARAYANK991]

Hi ,

Generally it helps if you upload a workbook with data in it.

Narayan

 

[Dan Hollingworth]

Thanks for the tip

File attached

 

[NARAYANK991]

Hi ,

See if this works.

Narayan

 

[Dan Hollingworth]

That is fantastic!

Thanks so much

Can you explain how this works, I'd like to know the why and how, I appreciate that you've done it but I'd love to understand it.

 

[Khalid NGO]

Hi Dan,

One more, No-CSE:

=IFERROR(INDEX($G$4:$J$10,MATCH(B2,$F$4:$F$10,0),MATCH(A2,{50,60.1,70.1,80.1},1)),"")

Regards,

 

[Dan Hollingworth]

Thanks guys, 2 great solutions