This is my current situation: I have an excel spreadsheet for my work. On Sheet 2 (labeled DATA)
there is every student in my school along with info for each term they were registered (called reporting terms). So ID#'s are
listed multiple times in column A in DATA. ex: ID#12345 for Fall2010 reporting term (student enrolled) and ID#12345 for
Spring 2011 (student enrolled)
I would use this formula to look up multiple ID#'s and match them with their
corresponding counselor. Since counselor does not change across the semesters, it didn't matter if vlookup just brought up
the first value.
I created this formula to return multiple values for 1 iD# in
cell A2 to show me all reporting terms for that ID#: (ctrl+shift+enter)
This formula works great, but i have to pull down the formula to bring up all the reporting terms for the ID# in
I want to be able to copy and paste a list ID#'s in column A and have it return the all the reporting terms for
each ID# in column B.. is this possible?
ex: put ID#12345 in A2 and ID#23456 in A3, run formula and get something
1| ID#12345 | Fall2010 reporting
2| ID#12345 | Spring 2011 reporting
3| ID#23456 | Fall2009 reporting
4| ID#23456 | Spring 2010 reporting
Any help would be greatly appreciated!
I have also posted this
topic on MrExcel.com see http://www.mrexcel.com/forum/showthr...84#post2639584