In Cell Validation List & Linked Cell VLOOKUP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You can use an IF formula to prevent errors from showing. For example:

=IF(ISNUMBER(MATCH(C3,PhoneList,0)),VLOOKUP(C3,PhoneLookup,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.
 
Debra Dalgleish said:
You can use an IF formula to prevent errors from showing. For example:

=IF(ISNUMBER(MATCH(C3,PhoneList,0)),VLOOKUP(C3,PhoneLookup,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.



--
Debra Dalgleish


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.
Click to expand...
 
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.
 
You're welcome. Thanks for letting me know that the information on my
web site helped you.
 
Debra,
You seem to know your stuff pretty well so I'd like to ask a question.
I have a table of Member Types with associated Fee Types that is working
perfectly with VLookup when a member type is selected.
My problem is that I want the member to be able to enter a Minimum, Maximum
and Variance percentage MANUALLY, not pulled from the table.
However, the range they have available to them is based on their member
level, so their entry must be within that range.
For example;
A Gold Member may have a Minimum of 30%, a Maximum of 70% and a variance
maximum of 15%.
A Silver Member may have a Minimum of 40%, a Maximum of 60% and a variance
maximum of 10%.

In the Minimum cell, a Gold Member could enter a number as low as 30% up to
70%. A Silver Member could enter a number as low as 40% up to 60%.

In the Maximum cell, a Gold Member could enter a number as low as 30% (BUT
NOT LESS THAN THE NUMBER IN THE MINIMUM CELL!) up to 70%. A Silver Member
could enter a number as low as 40% (AGAIN, NOT LOWER THAN THE NUMBER IN THE
MINIMUM CELL) up to 60%.

I would like to have the numbers entered "validated" and a message to appear
if not within the ranges based on their member types. I've looked on your
site and many different places to combine the Validation Tables with Types
but with no luck. Can you offer any suggestion as to the best approach and
with an example of the function or code? Thanks!
 
Back
Top