Try again, Gary. Use this as a reference:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"G" wrote in message
...
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