I have searched all over this forum. I have gone to several different
websites suggested by other questions/answers. The one most like my scenario
is on xldynamic.com. I have 3 drop down boxes and box 2 is dep upon box 1
and box 3 is dep upon box 2. If GS is selected, I need to show N/A in column
2. The website showed me formulas for VB. I am not that comfortable with VB
to this extreme. Are there ways that I can stay use formulas in a data
validation by creating some type of list? Can I have an IF statement within
a lookup. I don't know what to do. Here is my data. Thank you!
NSPS YA 01
NSPS YL 04
GS N/A 12

Look he

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

BUT if I understand your data correctly, you can use VLOOKUP to get date
items 2 & 3.

Is this the case:

If NSPS selected, the column 2 =YA, column 3 =01?

"Karen" wrote:

I have searched all over this forum. I have gone to several different
websites suggested by other questions/answers. The one most like my scenario
is on xldynamic.com. I have 3 drop down boxes and box 2 is dep upon box 1
and box 3 is dep upon box 2. If GS is selected, I need to show N/A in column
2. The website showed me formulas for VB. I am not that comfortable with VB
to this extreme. Are there ways that I can stay use formulas in a data
validation by creating some type of list? Can I have an IF statement within
a lookup. I don't know what to do. Here is my data. Thank you!
NSPS YA 01
NSPS YL 04
GS N/A 12