LOOKUP problem!!!


G

Guest

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top