Forum Discussion

Marty92's avatar
Marty92
Copper Contributor
May 31, 2022
Solved

Text in one cell automatically gives prices in an other cell

Hi!

I need help to get prices automatically in the cell. If I have Person 1 getting apple, I want the next cell to show 50, and if another gets orange I want the cell to show 30. I tried with IF. formula, but I can’t seem to get it to work. Someone that can help me with this? I have tried to google it but can’t find an example to help me.

Screenshot of the example:

 

Thanks for your time 

 

 

Resources