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
 

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

Similar Threads

I need a cell to be blank. 4
Names and Separate Worksheets 4
sorting through unknown source data as it is entered 1
how to reference external refereces from a list 7
Advice on sumif - more than one criteria 1
How do I make worksheet2 = to worksheet1? 2
Syntax for using variables in a cell formula to reference paths/fi 4
Finding min date value with hidden zeros with vlookup 4

Top