Using IF for data validation

[Closed]
Report
Posts
1
Registration date
Friday April 12, 2013
Status
Member
Last seen
April 12, 2013
-
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
-
Would like to seek your assistance. I trying to make a condition using data validation. this is the scenario:
for column C8 (this is the dropdown list Customer: A, B, C D). Each customer has diff products. I created Name manager for each customer (e.g. AItems - for A customer; BItems; CItems and DItems.
I listed in column AA and AB the details:
column AA Column AB
A Popcorn
A Coke
A Cupcake
A Candy
B Burger
B Fries
C Coffee
C Tea
D Rum
D Beer

How can I use IF statement for this? I tried this condition but didnt work. =IF($C$8="A",AItem,BItems,CItems,DItems)
Appreciate your recommendation.

1 reply

Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
43
Hi Wowexcel,

For this I would like to use a "dependent drop down lists containing unique distinct values". Please check the below mentioned link for details on how to create this:

https://www.get-digital-help.com/create-dependent-drop-down-lists-containing-unique-distinct-values-in-excel/

Try this and check if it helps.

Please revert for clarification.