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
Bookmarks