Searching for values with formulas

Question

I need to make a list of which student is taking what kind of exam on which date and time.

The sheet with all the data looks like this:

This is per student but not per date.

I would like to have a tab per exam AND time. So exam Dutch is taken at 06-06-2019 at 10:00h, 12:00h and 14:00h. Tabs should be like: tab1 all students that take exam Dutch at 06-06-2019 10h, tab2 all students that take exam Dutch at 06-06-2019 12h, etc.

The order of columns can't change because the sheet as in the example is also generated with formulas etc. from other sheets.

I tried the VLOOKUP formula but this can't search on the left. I have absolutely no idea how to solve this.

I'm not looking for a ready to use answer. Just push me in the right direction.

@player0 The solution JPV posted works perfect!

Nina Bakker
– Nina Bakker

2019-05-17 14:02:48 +00:00
Commented May 17, 2019 at 14:02 — Nina Bakker
– Nina Bakker, Commented May 17, 2019 at 14:02

JPV · Accepted Answer · 2019-05-17 11:36:08Z

2

You could use filter() or query(). Assuming 'achternaam' in column A and 'exam Dutch' is in column E, you can try

=query('SheetwithData'!A:E, "Select A where E contains '06-06-2019 10:00'", 1)

Replace the sheet name with the actual sheet name.

answered May 17, 2019 at 11:36

JPV

27.4k4 gold badges37 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Searching for values with formulas

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related