# 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!

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))

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.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1