On Wed, 22 Jul 2009 09:52:01 -0700, Jeremy
wrote:

I am looking for a formula to place what is in B in either C or D based off
of if A has an EX or ENT in it. EX goes in C where ENT goes in D. Below the
first example is what I have and the second is what I would like.

Thank you



A B C D
1 CGVEHEX 1500
2 ENTB2A0 2500
3 EX NM51B1A1 2600
4 ENT W NM 2780

Example 2
A B C D
1 CGVEHEX 1500 1500
2 ENTB2A0 2500 2500
3 EX NM51B1A1 2600 2600
4 ENT W NM 2780 2780


Put this formula in cell C1:

=IF(NOT(ISERROR(FIND("EX",A1))),B1,"")

and this formula in cell D1:

=IF(NOT(ISERROR(FIND("ENT",A1))),B1,"")

Copy cells C1 and D1 down as far as needed.

Hope this helps / Lars-Åke