Dynamic Validation Not working?

[countryfan_n]

Hello Friends,

I need your help please.

In the attachment, sheet "CCR", column C.
Is supposed to have the validation option that shows a drop down menu, that is dynamic and relying on whatever is chosen in column B.
The validation on col. B works fine, but the validation in col. C failed to work.
I tried over again, but can't seem to find out what the problem is.


Your kind help is truly appreciated,
Nawaf

[Bob Phillips]

Change the DV formula to

=INDIRECT(RIGHT(B21,1))

[JONvdHeyden]

See attached. I don't think much of that naming convention. You have Lost to A named as 'A', and then you have Declined:A named as 'I'. How have you arrived at that naming convention?

[countryfan_n]

Thanks A LOT Guys,

I was wondering though XLD, your resposne works, for all selections except for "Lost To: C" And "Declined: C" Why? the formula in the DV should be OK for all?

Your kind response to that is highly appreciated.

[Bob Phillips]

I think Jon spotted something that I missed that explains it all. Your naming convention is bizarre, Declined:A named as 'I' etc.

I would suggest that you have a lookup table to lookup the B value to get the equivalent name to use in C.