Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Look Up challenge
I hope that the picture will be displayed or you could click on the link and
open it up. http://www.eonstone.com/F250/list_1.jpg This is my challenge: I got this spreadsheet where I keep track of employees who are been on the events. I want to create a separate €œlookup€ spreadsheet where I will have a drop down list of event names (1). Once I select the event from dropdown list, I would like to display a list of attendees (3) who been on that event (2), marked by €œX€ I think this is calling for multicell array formula. Thank you for the help, And I hope that you will be able to open my challenge illustration Guntars |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Look Up challenge
Hi
Try looking data validation and lookup functions in the Help -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "Guntars" wrote: I hope that the picture will be displayed or you could click on the link and open it up. http://www.eonstone.com/F250/list_1.jpg This is my challenge: I got this spreadsheet where I keep track of employees who are been on the events. I want to create a separate €œlookup€ spreadsheet where I will have a drop down list of event names (1). Once I select the event from dropdown list, I would like to display a list of attendees (3) who been on that event (2), marked by €œX€ I think this is calling for multicell array formula. Thank you for the help, And I hope that you will be able to open my challenge illustration Guntars |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Look Up challenge
Here's one non-array construct which should deliver the desired functionalities
Assume the source data as posted is in a sheet named: x where the "events" listing is in F5 across (your area #1) names are listed in D13 down (area #3) with corresponding markings "x" in cols F across (area #3) In another sheet, Assume B1 contains a DV to select the events (area #1) Put in A2: =IF(OFFSET(x!E13,,MATCH($B$1,x!$F$5:$IV$5,0))="x", ROWS($1:1),"") Leave A1 empty Put in B2: =IF(ROWS($1:1)COUNT($A$2:$A$100),"",INDEX(x!$D$13 :$D$100,SMALL($A$2:$A$100,ROWS($1:1)))) Copy A2:B2 down to say, B100, to cover the expected extent of source data. Minimize/hide col A. B2 down will return the required results dependant on the selection made in B1, ie the list of names marked with an "x" for the particular event selected in B1. All results returned will be neatly bunched at the top. Success? Celebrate it, click the YES button below. -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "Guntars" wrote: I hope that the picture will be displayed or you could click on the link and open it up. http://www.eonstone.com/F250/list_1.jpg This is my challenge: I got this spreadsheet where I keep track of employees who are been on the events. I want to create a separate €œlookup€ spreadsheet where I will have a drop down list of event names (1). Once I select the event from dropdown list, I would like to display a list of attendees (3) who been on that event (2), marked by €œX€ I think this is calling for multicell array formula. Thank you for the help, And I hope that you will be able to open my challenge illustration Guntars |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Look Up challenge
Excel 2007 Pivot Table
No formulas of any kind needed. http://www.mediafire.com/file/zylmmbuomxf/05_24_09.xlsx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Who's up for a Challenge? | Excel Worksheet Functions | |||
Challenge for Anyone to take it on. | Excel Worksheet Functions | |||
A challenge | New Users to Excel | |||
A Challenge | Excel Discussion (Misc queries) | |||
A Challenge | Excel Worksheet Functions |