Forum Discussion
Marty92
May 31, 2022Copper Contributor
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
Marty92 Use XLOOKUP (or VLOOKUP) if your Excel version does not support it. Example attached.
- Riny_van_EekelenPlatinum Contributor
Marty92 Use XLOOKUP (or VLOOKUP) if your Excel version does not support it. Example attached.
- Marty92Copper ContributorHi! Thank you so much! 😄