excel formula "or"

  • Thread starter Thread starter unco_dunco
  • Start date Start date
U

unco_dunco

Hi I need serious help, can anyone figure this out for me

I have a drop box say in B1, containing a list of names

I want to have B10 to have a different response to each of those name
listed in B1.

So if I select at random a name "unco" from the dro box, it will resul
with the word "works" in cell B10, sytematically if I select from tha
drop box the word "dunco" it will have another word as the result.

This has had me going for days trying to figure it out.

Please help this unco

:
 
Use a lookup table. See help for VLOOKUP.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Bob, that helped a little, but did not really sort out my problem, Fo
example it created a list in a combo box, but then it only counted th
list not providing the option to alter the outcome other than countin
the position of the data in that list

Is there a way to alter the end result
 
I meant set the value in B10 by using lookup based upon the value selected
in B1. I also assumed by the fact that you said that you had a drop-down in
B1 that you were referring to Data Validation not a Combobox.

I also do not understand what you mean by '.. only counted the list ..'.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top