Suppose I have a mapping of string to string as follows:
- "orange" => "balloon"
- "red" => "bicycle"
- "blue" => "bird"
Is there a formula that can be constructed (say in B1) such that it will lookup the value from another cell (say A1) and dereference the string?
For example, if A1 is "red" then B1 would be "bicycle". If the color does not exist (e.g. "purple"), then I want to output a string like "NOT FOUND".
I need this to be completely in-line - in the formula itself, without writing the data to any cells/tables.
Also, prefer if it's not just one big If/Then/Else formula (which is my punt plan). Looking for something more terse.