populating data after picking drop-down choice
Hi Everyone,
I'm trying to make data populate after choosing a field from a drop-down...which I got to work but the problem is it only shows one row of the data?
example: say I have Pre K - Grade 12 in a drop-down then I choose grade 12 and it has 14 people in there my formula "=IF($E14="", "", INDEX(Names!B:B, MATCH($E14,Names!$F:$F, 0)))" but it only shows one of the 14 on the sheet.
All my data are in on separate sheets in 1 workbook.
Can you please help me thanks.
---Will
Last edited by WGN; 09-22-2011 at 09:47 AM.
It is better to upload a sample workbook with sample data and your desired results
In order to attach a file Click the Go Advanced button, and click on the Manage Attachments button
Azam
If you want to say Thank you to a member, click the reputation icon (Star) in the left bottom of the post.
For prompt answer, be descriptive, concise, short, direct, and to-the-point.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks