Need a list box to show a certain list

[rlkerr]

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.

[icestationzbra]

something like this?

http://www.contextures.com/xlDataVal02.html

[rlkerr]

Oh great!!!! That works perfect. Thank you so much.

[Cutter]

@ rlkerr

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.