=IF(ISERROR(SEARCH($C$1,A2)),"",B2) =IF(ISERROR(SEARCH($D$1,A2)),"",B2)
=IF(ISERROR(SEARCH($C$1,A3)),"",B3) =IF(ISERROR(SEARCH($D$1,A3)),"",B3)
=IF(ISERROR(SEARCH($C$1,A4)),"",B4) =IF(ISERROR(SEARCH($D$1,A4)),"",B4)
=IF(ISERROR(SEARCH($C$1,A5)),"",B5) =IF(ISERROR(SEARCH($D$1,A5)),"",B5)

Where C1 = EX and D1 = ENT.

Loads of ways to do this - BUT perhaps the best way would be to use Regular
Expressions..!!

"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