the enclosed sheet shows a vlookup to find student in a particular homeroom how do I get the look up to show all the instances of the query? so if i put 105 in the in g1 it shows all that's in that HR
the enclosed sheet shows a vlookup to find student in a particular homeroom how do I get the look up to show all the instances of the query? so if i put 105 in the in g1 it shows all that's in that HR
Last edited by komet12; 06-04-2012 at 09:00 AM.
In G2 enter:
=IF(A2=$G$1,COUNT($G$1:G1),"")
copied down
Then in L5:
=IFERROR(INDEX(A$2:A$28,MATCH(ROWS($A$1:$A1),$G$2:$G$28,0)),"")
copied down as far as you need and across the columns.
P.S. Please change title to more descriptive of the problem, like "Multiple Results Lookup" or similar
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thank YOU !!!
You are welcome... but kindly update your title as requested.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks