Excel Problem

[mayurgodbole]

I am trying to use excel to return a value by matching two criteria. Basically im using it to return fire-proofing area for a specific w section. The formula should look up the width of flange then look up the depth and return the corresponding value for FP. Can anyone please help me with this?
Thank You.

 

[mayurgodbole]

Let me explain my problem
I have Flange Width W in 1 column and Depth d in Column on one worksheet. I have the section data including the Fireproofing quantity/ft on one sheet. I want a formula that checks the depth and width matches it to fireproof quantity n returns that value in sheet 1.
i think i made it clear as mud!!!!

 

[MintJulep]

2-D lookups need a combo of MATCH and INDEX.

 

[yogia]

Hi mayurgodbole:

To elaborate what MintJulep stated, try the following array formula ...

=INDEX(FP_Col,MATCH(1,(W_Col=W)*(D_Col=D),0))

Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC
ANAND Enterprises LLC

http://www.energyefficientbuild.com

 

[MintJulep]

I wouldn't do it as an array formula.

I would MATCH width as row id, and depth ad column id.

The non-array form of INDEX would then return the single desired value at the intersection.