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