Formula creation lookup multiple matches

Hi there! I’m new to the forum, and just know enough about Excel to know I need to ask for help!

The file with which I am working has several worksheets. Is it possible to create a formula that will pull information from several rows on a separate worksheet, at once?

Here is the “Nebraska version” of this situation:
We are having a pig sale. On one worksheet (Sale List), I list who purchased each pig…as it comes up to auction. On another worksheet (Receipt), I would like to type in the buyer’s individual number, and have the information about any pigs they bought fill in accordingly.

I currently have the formula set up where I can type in each pig’s tag number, and the information about that pig will fill in. I would just like to go a step further. I am just SURE it’s possible, I just don’t know how to collect multiple rows in a formula!

Thanks in advance for the assistance. I can attach the file if someone wants to look at it-
Kari

Have you looked into VLOOKUP? See Excel help for more.

Here's the file I'm using. Please don't mind that I took last year's addresses/ phone #s out!

I used a VLOOKUP for the individual rows. But how to expand that to multiple rows? Hmmm...

Can you elaborate on what you mean by:

But how to expand that to multiple rows?

Where exactly are we looking and what are we expecting to get?

Note: I changed your original title the first time as it did not conform to forum rules... please don't change it back again....

Try this:

In B2 enter formula:

Please Login or Register  to view this content.

This formula needs to be confirmed by holding the CTRL and SHIFT keys down and then hitting ENTER... then copy it down as far as you want.

In C2 enter formula:

Please Login or Register  to view this content.

This is a normal formula and you only need to confirm with ENTER

Then copy down all the way and across the remaining columns.