Return multiple results for HLOOKUP

[TonyFletcher]

I am an excel novice and am entering hundreds of lines manually so I need help.
Is there a way to do an HLOOKUP or some other formula/macro that will return multiple results?
For instance I want to look up an ID # for what a list of clients are ordering. I attached an example.

Sorry if this is already covered. Please let me know if this topic is already covered.

Thank you in advance for the help.

[NBVC]

Assuming you inputting one ID in A2 of Sheet2, then in Sheet1 add a helper row to find matches...

Say in F2, enter:

Please Login or Register  to view this content.

copied across

Then in Sheet2, B2 enter:

Please Login or Register  to view this content.

This gives count of matches.

Then in say, A4 enter:

Please Login or Register  to view this content.

copied down as far as you need.

You will need to adjust ranges to suit your actual data.

[TonyFletcher]

I need to return the Client #s (E1:N1) for every '1' that is marked in E4:N13 per each ID# (B4:B13.)

An example of what I would want it to return for B4 (ID #123) would be 344,345,346 and 347. I need to see which product ID # (B column) each Client (E1:N1) is ordering. It must be relatively simple.

Thank so much. I really need a tutorial in excel so if there are resources I'd def. use them.

[NBVC]

Then try this:

P4:

Please Login or Register  to view this content.

copied down

In Q4:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER and copied across 10 columns and down.