I'm trying to find a way to extract multiple records from a List. I'm looking, I guess, for the multiple-record extract version of dGet(). Any ideas?
I'm trying to find a way to extract multiple records from a List. I'm looking, I guess, for the multiple-record extract version of dGet(). Any ideas?
Last edited by bstubbs; 02-18-2009 at 09:14 AM.
If lookup value is D1
Formula: =INDEX(B1:B8,SMALL(IF(A1:A8=D1,ROW(A1:A8),""),ROW())) + Ctrl + Shift + Enter
See attached workbook.
Last edited by Steve R; 02-11-2009 at 01:32 PM.
Thank you, sir! You're a gentleman and a scholar.
Hi
I'm trying to get that formula to work in a spreadsheet where I don't start in the top row (1), this has led to the formula not working and giving me the wrong results. Any way to change that formula to suit this case? I have attached my document if you can take a look and give me a suggestion that would make it work? Cheers
Forum Rules
Please read and adhere to these simple rules!
1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change the title of the thread, click EDIT on the original post, then click the Go Advanced button, then change the title. If two or more days have passed, the EDIT button will not appear, and you need to ask a moderator to change the title.
2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread.
Ben Van Johnson
Hello Grizz,
Please take a few minutes to read forum rules. Rule #2 says,
2. Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread.
So, please start a new thread.
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks