Using IF for data validation

Closed
Wowexcel Posts 1 Registration date Friday April 12, 2013 Status Member Last seen April 12, 2013 - Apr 12, 2013 at 01:12 AM
Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 - Apr 12, 2013 at 01:54 AM
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 response

Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
Apr 12, 2013 at 01:54 AM
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.
0