Forum Discussion
If cell range has specific number, it returns a corresponding value
Hello,
I am trying to build a formula where in it will look at a cell range and look for specific numbers and if it matches return a corresponding text.
Ie. i would like it to look at the BU column and look at each cell for the number 1. If it finds 1 i want it to return Rio in the return column. If it finds 2 i want it to return Australia, if 3 i want it to return India and so on.
Any help with this would be greatly appreciated.
| BU | Ops | Return |
| 1 | Rio | |
| 2 | Australia | |
| 3 | India | |
| 1 | Spain | |
| 3 | Arizona | |
| 2 | Alaska |
1 Reply
Enclosed in the file is a simple and quick solution suggestion.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
