Thanks, it worked. I was going crazy trying to figure this one out.

What my problem was is that I had a whole bunch of text entries I needed
converted over, but it came out to too many values to keep nesting IF
statements or LOOKUP values into one formula. But I noticed I could just key
off of the first two charachters and save a bunch of IFs. So now I know.




"Phil G" wrote:

I'm programming a bunch of IF statements into a spreadsheet.

The statements take the text of one cell and post a formula result in
another cell, such as: IF B2 = "SP-129", B3="Supply"

I was wondering if I can have the formula just key off of the first two text
charachters in the cell, shortening it to something like: IF B2=SP..,
B3="Supply"