Help! Do you know Excel?

[Feebes]

I am trying to do something with excel and it has gone above my ability or knowledge to accomplish. I tried to explain it as best I could on this screen cap. Thanks

Screen Cap

 

[TheoPetro]

some type of "IF(" would work. I think theres a "text(" thing too. Its been a while and I have an accounting test or I would help more.

 

[ShawnD1]

I think what you might be trying to do is called a vlookup table
There is also hlookup which does a similar thing, but it reads tables by row rather than column.