Lucy Zeng
Califonia
Member
Members
Forum Posts: 10
Member Since:
October 19, 2017
October 19, 2017
Offline
Do you know how to use the tool of index and match to find out the item with more multiple conditions?
I have a sample in the work as attachment which I have to fill up the students name under the course. The data base is in table 1. Then I have to set a formula into table 2 to draw the student names under the course.
I don't know how to use index and match together. Or do you have better idea to do it?
Table1 | Course | |||||||
Name | MA1 | MA2 | MA3 | MA4 | MA5 | MA6 | MA7 | MA8 |
John | √ | √ | √ | √ | ||||
Rosa | √ | √ | √ | √ | √ | √ | ||
Linda | √ | √ | √ | |||||
Shelley | √ | √ | √ | √ | √ | √ | ||
Romanda | √ | √ | √ | √ | √ | √ | ||
Beth | √ | √ | √ | √ | √ | √ | ||
Ryan | √ | √ | √ | √ | ||||
Brandon | √ | √ | √ | √ | √ | |||
Kate | √ | √ | √ | √ | ||||
Jessie | √ | √ |
Table 2 | MA1 | MA2 | MA3 | MA4 | MA5 | MA6 | MA7 | MA8 |
Rosa | John | Linda | Rosa | John | John | Rosa | John | |
Shelley | Rosa | Shelley | Linda | Rosa | Rosa | Linda | Shelley | |
Ryan | Shelley | Beth | Romanda | Shelley | Romanda | Shelley | Romanda | |
Kate | Romanda | Ryan | Beth | Romanda | Brandon | Romanda | Beth | |
Jessie | Beth | Brandon | Ryan | Beth | Kate | Beth | Brandon | |
Brandon | Jessie | kate | Brandon | Ryan | Kate | |||
SunnyKow
Puchong, Malaysia
VIP
Members
Trusted Members
Trusted Members
Forum Posts: 1432
Member Since:
June 25, 2016
June 25, 2016
Offline
Hi Lucy
You can take a look at the attachment.
It uses array formulas. You can read about array formulas here https://www.myonlinetraininghu.....ay-formula
You may have to modify the range to suit your needs. You will need to press CTRL+SHIFT+ENTER after entering the formula.
Hope this helps.
Sunny
Answers Post
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Jeroen Juwett, Victor Policarpio, Jeff Finkelstein, Marisa Bradshaw
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 286
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Marisa Bradshaw
Eugene Augustine
MacNaughton Finance
Tanu Rai
Ryan Tyree
Taza Tarwala
Ryan Tyree
Nishi Gurupersad
Tony Johlie
Ben Gerrey
Forum Stats:
Groups: 3
Forums: 24
Topics: 6870
Posts: 30095
Member Stats:
Guest Posters: 49
Members: 33661
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —