I am looking for a formula that will read an adjacent cell (in the example, the column "value") and return currency based on either "$", "€", or "£" values appearing.
i.e.
| value | currency |
|---|---|
| $10 | US |
| €20 | Euro |
| £20 | Pound |
So far I have =IF(ISNUMBER(SEARCH("$",adjcell)),adjcell,"dollar"), but I am not sure how to add an OR to the end of this formula to duplicate it for euro and pound symbols as well. How can I do it?
CodePudding user response：
=LOOKUP(1,0/FIND({"$","€","£"},adjcell),{"Dollar","Euro","Pound"})