I have used the vlookup function many times to compare 2 different list using
1,false. What I am trying to do now is create an on call form where if I have
a persons name in cell D5 it will fill in their contact info. I understand
that I need to use 2,false to get the info from column B, but I am getting
the #REF! error code
An example would be

In sheet 1 I have
A B C etc
Name phone cell phone etc
jim 1234
ellen 2345

Sheet 2

In cell D5 I have the name jim
I want cell B6 to be the Phone # 1234

The formula I entered in cell B6 is the same that i always used except for
the 2,false
vlookup(D5,SHEET1!A:A,2,FALSE)
This should look in column A for the value in cell D5 and return the value
in column B but I am getting the #ref! error
From what I can figur out this error means that the function is not
reconizing that there is any info in column B

That is what has me stumped

Any help would be greatly appreciated

Jim

Jim,

#Ref means you're making reference to cells that don't exist. Your VLOOKUP is looking in a
1-column range (A:A) and trying to retrieve data from the second column (the third
argument -- 2). Maybe you meant for it to look in A:B

--
Earl Kiosterud
www.smokeylake.com

Note: Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"AJL" wrote in message
...
I have used the vlookup function many times to compare 2 different list using
1,false. What I am trying to do now is create an on call form where if I have
a persons name in cell D5 it will fill in their contact info. I understand
that I need to use 2,false to get the info from column B, but I am getting
the #REF! error code
An example would be

In sheet 1 I have
A B C etc
Name phone cell phone etc
jim 1234
ellen 2345

Sheet 2

In cell D5 I have the name jim
I want cell B6 to be the Phone # 1234

The formula I entered in cell B6 is the same that i always used except for
the 2,false
vlookup(D5,SHEET1!A:A,2,FALSE)
This should look in column A for the value in cell D5 and return the value
in column B but I am getting the #ref! error
From what I can figur out this error means that the function is not
reconizing that there is any info in column B

That is what has me stumped

Any help would be greatly appreciated

Jim

Thank you Earl, you were right, your suggestion worked

have a great evening
Jim



"Earl Kiosterud" wrote:

Jim,

#Ref means you're making reference to cells that don't exist. Your VLOOKUP is looking in a
1-column range (A:A) and trying to retrieve data from the second column (the third
argument -- 2). Maybe you meant for it to look in A:B

--
Earl Kiosterud
www.smokeylake.com

Note: Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...
-----------------------------------------------------------------------
"AJL" wrote in message
...
I have used the vlookup function many times to compare 2 different list using
1,false. What I am trying to do now is create an on call form where if I have
a persons name in cell D5 it will fill in their contact info. I understand
that I need to use 2,false to get the info from column B, but I am getting
the #REF! error code
An example would be

In sheet 1 I have
A B C etc
Name phone cell phone etc
jim 1234
ellen 2345

Sheet 2

In cell D5 I have the name jim
I want cell B6 to be the Phone # 1234

The formula I entered in cell B6 is the same that i always used except for
the 2,false
vlookup(D5,SHEET1!A:A,2,FALSE)
This should look in column A for the value in cell D5 and return the value
in column B but I am getting the #ref! error
From what I can figur out this error means that the function is not
reconizing that there is any info in column B

That is what has me stumped

Any help would be greatly appreciated

Jim