Index and Array

**DaniJ** · 02-11-2021, 05:23 PM

Hi

I'm hoping to put together a supervision schedule. I have a list of staff and the day they work, and a list of learners and the day they work. I want to have a drop down to select the day of the week and then an auto-populated list of staff.

I've attached a sample of my current table and what I'd like the output to look like

Thanks in advance!!

**protonLeah** · 02-11-2021, 07:55 PM

Named Ranges:
DteList =Sheet1!$A$3:$A$10
LearnerGrid =Sheet1!$E$3:$AT$10
RptDate =Sheet1!$B$13
StaffList =Sheet1!$B$3:$B$10

Data Val list (B13) =DteList
Staff (C13):

Please Login or Register  to view this content.

Learner list (C14:C53)***

Please Login or Register  to view this content.

***Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).

Index and Array

LinkBack

Thread Tools

Rate This Thread

Display

Index and Array

Re: Index and Array

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Index/Aggregate formula calculates correct row but does not yield name from Index array

Use Index Match or lookup to create array from array

[SOLVED] If range contains one of the values in the array, return the index of the array

Create an array formula to obtain the average of an array of index and match function

lookup an array in a row in a index and return a value if array matches any row in index

Index Match array equation with sub-array calculation

Bookmarks

Bookmarks

Posting Permissions