Formula help I don't even know how to word my problem

**mariep460** · 02-02-2019, 02:10 PM

I have data in cell C2 and D2,
if C2 is Found on list in column K and

D2 is found on Row L2-T2, return value of corresponding cell.

for the first data is should return 3.36 since the weight is .05 and zone is 6

I've attached my spreadsheet.

Please help!!!! :confused

**Pete_UK** · 02-02-2019, 02:28 PM

Change the formula in C2 to this:

=ROUND(B2*0.16,2)

and copy down, then you can use this formula in E2:

=iferror(INDEX($L$3:$T$18,MATCH(C2,$K$3:$K$18),MATCH(D2,$L$2:$T$2,0)),"")

Copy this down as far as you need to.

Hope this helps.

Pete

**KOKOSEK** · 02-02-2019, 02:36 PM

Due to the fact that in col C You have not rounded results I have put rounding into formula to get proper value as in col. K.
Put into E2:

Formula:

Please Login or Register  to view this content.

and drag it down

**mariep460** · 02-02-2019, 03:23 PM

Thank you so much!

**mariep460** · 02-02-2019, 03:24 PM

OMGEEE Pete you are such a life saver, Thank you for all your help, it worked perfectly as it should.

**AliGW** · 02-02-2019, 04:49 PM

Please note for the future that you will need to try to articulate your problem in your thread title. In the case of this thread, you could have said that you were trying to look up results based on multiple criteria.