herpasymplex10
Board Regular
- Joined
- May 26, 2005
- Messages
- 224
I think this is possible, but i could be wrong.
I've got a formula
=IF(AND(F2="F",D2="PAP"),L2,"")
What i'd like is for the formula to look at just the last letter of the three letter code in D2
I've got a formula
=IF(AND(F2="F",D2="PAP"),L2,"")
What i'd like is for the formula to look at just the last letter of the three letter code in D2