Hi, I'm looking for a formula that recognizes a specific word of text in
a cell and then does a lookup in another column.
Example: B2 lists a type of film such as BASF or AGFA. Columns C,D, and
E represent size dimensions and column F is the square inches of the
corresponding cells in that row. (B2= BASF, C2=8, D2=x, E2=10, F2=80)
So, I'd like to find a formula to put in G2 that would return the
square inches only if BASF appears in B2 and returns 0 or blank if
not.

B C D E F G
BASF 8 X 10 80 80


Many thanks for your help!


--
pdgood
------------------------------------------------------------------------
pdgood's Profile: http://www.excelforum.com/member.php...o&userid=31623
View this thread: http://www.excelforum.com/showthread...hreadid=526601