lookup w/ the ability to return multiple values in order

[mcantrell]

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

[NBVC]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[mcantrell]

I went ahead and added a dummy workbook

[NBVC]

Try this:

In F19 add formula:

Please Login or Register  to view this content.

In G19 add formula:

Please Login or Register  to view this content.

and copy down.

In a free cell, say B6 enter:

Please Login or Register  to view this content.

Then in C3 enter:

Please Login or Register  to view this content.

copied down

and in D3:

Please Login or Register  to view this content.

copied down

[mcantrell]

thx...your fix did the job