Returning multiple results from Vlookup

**churley129** · 10-04-2011, 02:17 PM

I have a spreadsheet that has a bunch of data on it. I would like to be able to plug in one number "1000" to cell A2 of a new spreadsheet and populate cells B2:H10 with the corresponding data from the other spreadsheet. right now I am only able to return one line of information. Please see attached. PLEASEEEEE HELP.... Thanks in advance!!

**NBVC** · 10-04-2011, 02:21 PM

in the Original Data sheet, add a column with formula in I2:

=IF(A3='Need Help'!$A$2,COUNT(I$2:I2)+1,"")

copied down

then in J2:

=MAX(I:I)

Then in B2 of the Need Help sheet, enter formula:

=IF(ROWS($A$1:$A1)>'Original Data'!$J$3,"",INDEX('Original Data'!B:B,MATCH(ROWS($A$1:$A1),'Original Data'!$I:$I)))

copied down and across the columns.

**churley129** · 10-05-2011, 11:16 AM

After entering in the recomended formulas, I am still not coming up with any corresponding data. Attached you will see that it does not show up as intended. PLease advise on where I am going wrong. thanks so much for your help with this. this is my first time using this forum and its great to see that there are people out there willing to help. thanks again!!

**NBVC** · 10-05-2011, 11:30 AM

Here you go.

Your formula in the first sheet should start from I2.

And your formula in the summary sheet was referencing the wrong cell in the first sheet for max count.

**churley129** · 10-06-2011, 08:24 AM

Excellent! Thanks so much!

**NBVC** · 10-06-2011, 08:54 AM

You are welcome,

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save