List/Drop downs and using a custom formula

[mmaffe23]

Hi,

I want to insert a formula within a dropdown box.


I have an dropdown with international /Domestic, the next column is where I want to say if international then use list A, if Domestic use list B.


Any assitance will be helpful.

 

[amrit1186]

Hi mmaffe23


You can use the if formula in the Data Validation->List.


For eg. Name the ranges as A and B.


Then the formula goes as =if(Cell = "International",A,B)


Amritansh

 

[mmaffe23]

Thank You!