I have some problem with LOOKUP function, when I type:
=LOOKUP("Ω",{"";"ok"}), the result is "ok",
=LOOKUP("1",{"";3}) or =LOOKUP("1",{"";"3"}), the result is "" (blank).
In other cases, I write following formulars:
=LOOKUP("Ω",{"fail";"ok"})
=LOOKUP(1,{"";"ok"})
=LOOKUP(1,{"";3})
=LOOKUP(1,{2;3})
=LOOKUP("1",{2;3})
They always return the same result "#N/A".
Please, instruct me the performance method of LOOKUP function in aforesaid formulars.
For more details, I wrote in attached file, thank you for anyway!
Bookmarks