|
|
"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.
|