IF THEN in cell?

[HeatherLou1974]

I am taking over a spreadsheet that has a list of options that is specific to
one name in it. Currently when you choose this guy's name, the user has to
hunt and peck for the choices that are specific to him.
Is there a way that I can force Excel to display just those choices when his
name is chosen?

 

[Bernie Deitrick]

Heather Lou,

Visit here:

http://www.contextures.com/xlDataVal02.html

for a technique to do what you want.

HTH,
Bernie
MS Excel MVP