Returning multiple rows off of one data point

[EIBKev2_16]

Good morning-

I am having difficulty finding a formula/lookup to return multiple lines of data. In the attached I have a data page and a sale order page. I am trying to input the order number on the form page and then have all of the equipment information automatically populate based off of the order number. With a vlookup I can only return the first line of the data and I can't figure out how to pull in the additional lines. I have attached a test file. Any ideas?

Thanks in advance

[NBVC]

See attached...

formulas in first row need to have ranges adjusted to your actual database...

then they need to each be re-confirmed with CTRL+SHIFT+ENTER not just ENTER and then copied down.

[EIBKev2_16]

Thank you very much, saved me a lot of time. Appreciate your help!

[NMullis]

Hi NBVC,
Can you explain what is going on in the formulas of the file you attached so I can replicate in one of my files?

Thank you,
N

[NBVC]

Hi NBVC,
Can you explain what is going on in the formulas of the file you attached so I can replicate in one of my files?

Thank you,
N

See this similar thread with explanation attached...

http://www.excelforum.com/showthread...18#post1833718