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

You want to check out VLOOKUP
goto excels help to find out how to do it


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

If *only* the exact data "BASF" is in B2, try this:

=IF(B2="BASF",F2,"")

If BASF can be combined with other text in B2, you could try this:

=IF(ISNUMBER(SEARCH("BASF",B2)),F2,"")

You can copy down as needed.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"pdgood" wrote in
message ...

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

One play which might also suffice ..

Assume we list across in

G1: BASF
F1: AGFA
etc

(these will be the col headers)

then we could put in G2:
=IF(TRIM($B2)="","",IF(TRIM($B2)=G$1,$F2,""))
then copy G2 to F2 (or more, depending)
and then fill down as far as required

That'll give us the returns from col F (square inches)
neatly under each of the headers in G1 across
(it'll return blanks: "" otherwise)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"pdgood" wrote in
message ...

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