ExcelBanter - IF THEN in cell?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - IF THEN in cell? (https://www.excelbanter.com/excel-worksheet-functions/179974-if-then-cell.html)

HeatherLou1974

IF THEN in cell?

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

IF THEN in cell?

Heather Lou,

Visit he

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

for a technique to do what you want.

HTH,
Bernie
MS Excel MVP

"HeatherLou1974" wrote in message
...
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?

All times are GMT +1. The time now is 10:31 PM.