Replacing/Adding text in a different column

[zmonaghan]

Hi -

I have a column with stock numbers (1 or 2 letters with 5 digits following). I need to them to match with the correct store in another column - The store is determined by the first 1 or 2 letters (ex - KU12345 would match Jones Kia and B67890 would match Bloom Chevrolet . Also, some of the store names are not listed.

Would if then statements be the best choice? If so, what's the formula?

Thanks,
Zach

 

[sandy666]

it looks like Merge option but without representative example data of source and expected result it's hard to say something more