Hello folks!
First time poster, big time stuck!
My problem is making a functional table where I cant enter a name and then get results for all insances when that name appears and on what kind of activity.
The format is really easy:
A1: Date
A2: Activity
A3-A20: All participants
The same general design goes from A-AAA.
Now what I would like to do is enter a name and lookup that name in A3:A20 and if found i want to know the date and activity, but here is the kicker, i also want the searc to go from A3:A20 to AAA3:AAA20.
I can do kinda the same thing, but opposite, namely choose a date and then see all participants and activity for that particular date, but that is really cumbersome when the need to parse the data comes upp (as it's a linked document, the people inputting data are not the ones who are depended of it).
So if anyone could shed some light, any light on the subject it would really make my day!
Bookmarks