VLookup Help

[RedExcel]

Hello to all.

I am trying to compile information from a results spreadsheet to a roster spreadsheet. My issue is that there are multiple lines of data on the results spreadsheet, and the roster only lists the member one time. How do I get a vlookup to return all the information from the results spreadsheet to multiple lines on the roster?

For example, Joe Smith got his B.S. from the University of Illinois, a Masters from the University of Wisconsin, and an MBA from Northwestern. On my roster, he is listed one time, but on the results spreadsheet, he has three rows, one for each school. Is there a way to combine these spreadsheets so I have accurate, and complete data?

Thank you for reading.

 

[Aladin Akyurek]

Control+shift+enter, not just enter, and copy down:

=IFERROR(INDEX(ResultsRange,SMALL(IF(ConditionRange=Condition,ROW(ResultsRange)-ROW(INDEX(ResultsRange,1,1))+1),ROWS($1:1))),"")

 

[Aladin Akyurek]

Condition stands for the look up value...

 

[RedExcel]

Thank you for that. I do have a follow up question though. Results Range, is that the column where I need the data pulled from then?

Condition stands for the look up value...

 

[Aladin Akyurek]

Thank you for that. I do have a follow up question though. Results Range, is that the column where I need the data pulled from then?

Yes.