Categories within a drop-down list

[JuniorGT]

Hopefully I can explain this clearly enough for someone to understand my issue.

I was asked to create an attorney confirmation form that could be mailed when printed. The form automatically returns the name and address of an attorney when selected from a drop-down list.

The drop-down list acts as the name of the attorney on the form and using the vlookup function returns the address and any other important information regarding that attorney.

The issue I'm dealing with arrives when the same attorney has more than one location. Since this is a mailing form I can only have the name listed as you would address it on an envelope. I am looking for a way to make a sub-category within the drop-down list so it will give you more detail about the attorney so you choose the correct location, but still only show the main category when selected.

Sort of looks like this I guess

Attorney A
- Miami location
- Ft. Lauderdale location
- West Palm Beach location

When you select any of the three options under Attorney A it will come up with the corresponding address and information for that account, yet will only show Attorney A on the form and not the subcategory.

Hopefully this makes sense to someone. Thanks for any help you can provide.

[zbor]

Look here, is this helps you:

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