| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
LOOKUP problem!!!
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| problem lookup function | Excel Worksheet Functions | |||
| Lookup Problem | Excel Worksheet Functions | |||
| Lookup Function Problem | Excel Discussion (Misc queries) | |||
| Lookup Problem | Excel Worksheet Functions | |||
| HELP -- probably a LOOKUP problem | Excel Discussion (Misc queries) | |||
Linear Mode
