In cell K8 is the word "Test". I need a formula that can scan all of the List Names starting in cell C37 and return all of the Symbols from column D with the list name "Test" to cell J10:J29. Can someone please help me with this?
In cell K8 is the word "Test". I need a formula that can scan all of the List Names starting in cell C37 and return all of the Symbols from column D with the list name "Test" to cell J10:J29. Can someone please help me with this?
Last edited by rhudgins; 02-16-2011 at 04:48 PM.
Try:
confirmed with CTRL+SHIFT+ENTER and copied down.Please Login or Register to view this content.
adjust ranges if necessary.
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.
Another way, involving a helper column (col A):
Had to add some "helper" data in column P. Modify the ranges in the formulas to match the number of rows of actual data you will have in rows 37:43.
On preview I see that NBVC has a more streamlined solution with one formula, and Cutter's solution including helper data is simpler than mine. I will leave mine here anyway if only for illustrative purposes.
Last edited by 6StringJazzer; 02-16-2011 at 04:39 PM.
Thanks all of these solutions work!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks