# LOOKUP function in creation of filtering list of employees

1. ## LOOKUP function in creation of filtering list of employees

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!  Register To Reply

2. ## Re: LOOKUP function in creation of filtering list of employees

Im not sure what you are trying to achieve with that formula, but if you want to extract unique employee numbers and then calc their totals, use these, copied down...

=IFERROR(INDEX(\$B\$3:\$B\$27,MATCH(0,INDEX(COUNTIF(\$F2:F\$2,\$B\$3:\$B\$27),0,0),0)),"")

and then
=IF(E3="","",SUMIF(\$B\$3:\$B\$27,E3,\$C\$3:\$C\$27))  Register To Reply

3. ## Re: LOOKUP function in creation of filtering list of employees

Thank you for your nice function, it works every good.
I'm trying to learn LOOKUP function to apply in other circumstances, I'm quite confused in this function, exactly, I don't comprehend it well, I really need more explaination and example from you.  Register To Reply