Multiple text cells in formula

[Oberst Hajj]

Hello everyone,

I need to write a formula that will look at the text in cell B14, if it is "Bomber" assign the value of cell C3, if it is "Recon" assign the value of C4, and if it is "Scout" assign the value of C5.

I have to do this for several cells and reference cells, but I think I can figure out how to string them together if I have that first part.

Thanks for any help you can give.

Keith

 

[Oberst Hajj]

In my case, B14 can only be one of those 3 options.