Compare Partial Content of a cell then return a different value

[brafter70]

I am trying to simplify the values of two cells. What I want to do is return a new value based on only a partial value of a cell. Probably easier to show you.

In the example, I'd like to associate just the first part of the text string in the cell to return a specific value. I'm assuming I would need to setup a separate table of the text strings and what they associate to. But after that I get stumped.

thanks for any help!

Bryce

[NBVC]

After you setup your table (which contains the codes in one column and the corresponding letter to apply in the next column), you probably need to insert a column between A and B if you want it to look like the sample solution table...

Then apply a Vlookup with an extraction of the left characters before the dash..

e.g.

=VLOOKUP(LEFT(A3,FIND("-",A3)-1),$J$1:$K$10,2,0)

where J1:K10 would be the reference to the table you setup up.

[brafter70]

Wow! Spot on! I re-read my post and I sounded like a blathering moron! How you were able to decipher that was amazing! Thanks for your help!

Bryce