I am trying to make a list box that will pull a certain list.


Example: If my list was in let's say B1, then if A1 is GOM then B1 would show all the Areas for GOM. If A1 was SYU then B1 would pull all the Areas for SYU.

I know how to do a validation list, but I don't know how to put a formula in it.