I'm using a lookup_value,lookup_vector,result_vector function as an array
formula to lookup first and last names in a two column array table and locate
their assigned groups. The table is sorted ascending to descending by last
name. The reason for using an array formula is that if I have more than one
person with the same last name I need it to identify which person with that
same last name. This works on a small test area to ensure the formula was
written correctly, but when I apply it to the entire table it matches all of
the wrong information. So if I want it to find JOE BROWN its finding MIGUEL
ZABOS and the resulting vector (in this case, manager assigned to MIGUEL)
isn't the correct result. Any ideas on what I'm doing wrong would be greatly
appreciated! Here's a sample formula I'm using:

{=LOOKUP(B2:C2,Sheet1!$A$2:$B$92,Sheet1!$C$2:$C$92 )}

It should find MARK (B2) BAKER (C2) and result in BAKER, MARK, but all it
returns is the number zero.