Hi

I need help with the following:
I have to look for 4 different words in two different cells and if one of the words is found i want to the return value to be the word that was found.

An easy example of what i want. If cell A5 contains one of the following numbers 1,2,3,4 or if cell B5 contains on of the following numbers 1,2,3,4 return that number, e.g. if the value 4 was found in either cell A5 or cell B5 then i want the return value to be 4. If no value is found it should return an empty cell.

This is how i wrote my formula but i dont know how to return the value that was found in the cell. See the question marksin formula

=IF(OR(ISNUMBER(SEARCH({"1";"2";"3";"4"};A5));ISNUMBER(SEARCH({"1";"2";"3";"4"};A5)));"????"; "")

I would appreciate it alot if someone can help me with this.

Regards,
Petar