I'm having a problem with the LOOKUP function ... it's referencing incorrect
rows! Here's my test Data

I'm in WORKSHEET2 (cell A1). Here's the other worksheet:

[WORKSHEET1]

A B C

N1 Fname1 Lname1
N2 Fname2 Lname2

When I enter the following in Worksheet2 (cell A1):

=LOOKUP("N1",WORKSHEET1!A1:A2,WORKSHEET1!C1:C2)

The cell shows "Lname2". Any suggestions?

Gary