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