Thank you very Much "contextures" has help me a bunch in the past thanx for
pointing me in the right direction. That was very similar to what I was
trying to do.

"Debra Dalgleish" wrote:

You should be able to reference the cell that contains the dropdown
list. There are instructions for a similar lookup he

http://www.contextures.com/xlOrderForm01.html

that might help you.

BEEZ wrote:

"Debra Dalgleish" wrote:


You can use an IF formula to prevent errors from showing. For example:

=IF(ISNUMBER(MATCH(C3,PhoneList,0)),VLOOKUP(C3,Pho neLookup,2,0),"")

Where the dropdown list is in cell C3, PhoneList is the list of number,
and PhoneLookup is the range with phone numbers and related data.

BEEZ wrote:

Hi, I am trying to make a drop down list using in cell validation
data...This won't let me then link it to a cell. This causes a REF# error in
the Vlookup cell belowit that is refernced to a phone number list I have
created.
Any Help Would Be Great
Thx In advance.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

The drop Down Menu Has different Customer names and I want the Vlookup on the line below to refrence what ever name you pick and fill in the next three lines below it with phone#, address, Zip code etc. I thought my problem lied in the fact that it was a drop down menu that was started by creating an in cell list with Data validation, which won't let me link a cell to the list. Am I going about it totally a wrong way.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

You're welcome. Thanks for letting me know that the information on my
web site helped you.

BEEZ wrote:
Thank you very Much "contextures" has help me a bunch in the past thanx for
pointing me in the right direction. That was very similar to what I was
trying to do.

"Debra Dalgleish" wrote:


You should be able to reference the cell that contains the dropdown
list. There are instructions for a similar lookup he

http://www.contextures.com/xlOrderForm01.html

that might help you.

BEEZ wrote:

"Debra Dalgleish" wrote:



You can use an IF formula to prevent errors from showing. For example:

=IF(ISNUMBER(MATCH(C3,PhoneList,0)),VLOOKUP(C3,Pho neLookup,2,0),"")

Where the dropdown list is in cell C3, PhoneList is the list of number,
and PhoneLookup is the range with phone numbers and related data.

BEEZ wrote:


Hi, I am trying to make a drop down list using in cell validation
data...This won't let me then link it to a cell. This causes a REF# error in
the Vlookup cell belowit that is refernced to a phone number list I have
created.
Any Help Would Be Great
Thx In advance.


The drop Down Menu Has different Customer names and I want the Vlookup on the line below to refrence what ever name you pick and fill in the next three lines below it with phone#, address, Zip code etc. I thought my problem lied in the fact that it was a drop down menu that was started by creating an in cell list with Data validation, which won't let me link a cell to the list. Am I going about it totally a wrong way.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html