V-Look up Help to Pull Multiple data points Hello - I need help with the followi
ID: 3565257 • Letter: V
Question
V-Look up Help to Pull Multiple data points
Hello -
I need help with the following issues.
In Sheet 1: I have a data set in Column H from 1 - 1167. In Column AB I did A V lookup as follows: =VLOOKUP(H2,'History 1'!$D$1:$E$6008,2,FALSE)
In Sheet 2 Named ' History1' : In Column D I want it to match the values with column H in the first sheet and pull the data from line E (1-6008). The problem is in Sheet 2 Column E there are multiple items that can correspond to the item in Column H in Sheet 1.
On Sheet 1 in Line AC, AD, AE, AF I waant to be able to populate the multiple items from Sheet 2, Column E.
HELP!!! I have tried copying multiple posts and nothing works.
Example:
Sheet 1:
Sheet 2 - 'History1'
Any help would reallly be appreciated!!!! Need helpp with this one ASAP!
Thanks to all in advance!!!!
Column H Column AB Column AC Column AD Column AE 00123 VLookup - Program 1 Program 2 Program 3 00124 Vlookup - Program 1 Program 3Explanation / Answer
In AB2 of Sheet 1, array-enter (enter using Ctrl-Shift-Enter) the formula
=IF(COUNTIF('History 1'!$D:$D,$H2)>=COLUMNS($A$1:A1),INDEX('History 1'!$E:$E,LARGE(('History 1'!$D$1:$D$10000=$H2)*ROW('History 1'!$A$1:$A$10000),COUNTIF('History 1'!$D:$D,$H2)-(COLUMNS($A$1:A1)-1))),"")
Then copy down to match coluumn H, and then copy to the right uuntil you get blanks at the end of every row.
I have assumed that "History 1" is thee actual name of your sheet (with the space) since thatt is how it is given in the formulaa...
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.