How to apply multiple IFs within a cell

I have a spreadsheet where several different words (text) can be entered into a cell. How can I program another cell to display different cell references depending on what the word is? Thanks for any advice.

sample sheet please showing data and expected results please.

Lookup or Vlookup is generally the solution for that type of issue.

But we definately need some details to provide working solutions.

Originally Posted by damerowa

I have a spreadsheet where several different words (text) can be entered into a cell. How can I program another cell to display different cell references depending on what the word is? Thanks for any advice.

Here is a picture of what I am trying to set upsample.jpg

Is that a REAL representation of what you're doing? Or a 'simplified' version of something more complicated?

If that's a real example, then this does 'exactly' what you wrote in the picture.
Trying to adjust it for something more complicated may not work the way you think

=CHOOSE(MATCH(A1,{"paper","canvas","plastic","cardboard"},0),100,120,B2+C2,D2)

FYI, actual books (.xlsx) make for much better examples for us to see what you're doing.

This shows me exactly what I need to know. Thank you very much Jonmo!!