LOOKUP problem!!!

Anne Troy · 09-06-2005, 02:05 AM

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

"G" <[email protected]> wrote in message
news:[email protected]...
> 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

Anne Troy · 09-06-2005, 11:05 AM

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

"G" <[email protected]> wrote in message
news:[email protected]...
> 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

Anne Troy · 09-06-2005, 02:05 PM

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

"G" <[email protected]> wrote in message
news:[email protected]...
> 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

Anne Troy · 09-06-2005, 04:05 PM

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

"G" <[email protected]> wrote in message
news:[email protected]...
> 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

G · 09-06-2005, 05:05 PM

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

Anne Troy · 09-06-2005, 05:05 PM

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

"G" <[email protected]> wrote in message
news:[email protected]...
> 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