Range and Multiple Formula Help

[csp2518]

HELP!! what I'm trying to accomplish is a multi search formula
I need to search column A:B for the a specified Sq. Ft. number that falls within the ranges of 100:199, 200:299 etc (Min Max).
Then search row 3 for the Entry Height specified and give the price that matches the Sq. Ft. & Height criteria.
Example:
Sq. Ft. Value : 333
Entry Height Value :12
Formula should give value of $9.95[

excel.JPG

[Richard Buttrey]

We always prefer workbooks so in the absence of one I'll suggest a solution

Use a VLookup()
Range: A4:H20
Lookup Value: I33
Column: J5 - where J5 contains the function =INDEX(C3:H3,1,J4) + 2
Last element: False

[csp2518]

Thanks! I'll give that a try and let you know if It works

[Gregb11]

Depending on your data, maybe something like this:

=INDEX(C4:$H$20,MATCH($I$4,A4:$A$20,1),MATCH($J$4,$C$3:$H$3,0))

[csp2518]

That worked perfectly, thank you for the help