Is there a way to have a primary name that will look up multiple sub names?
For example:
Is there a way to select Customer 1 in a combo box and then in
cell B1 (return value): Customer 1a
cell B2 (return value): Customer 1b
cell B3 (return value): Customer 1c
I'm guessing this would be called "Vlookup on Steriods", but have yet to find it.
thx
Bookmarks