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 |
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 |
All times are GMT +1. The time now is 02:47 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com