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