Forum Discussion
looking up across sheets?
To further complicate matters, i need this to work for all the classes, so there will be multiple columns
eg
So the Maths staffing may end up looking like this (for Years 7 & 8 for example):
Again, any help or suggestions would be very much appreciated!
Thanks
You may use INDEX/MATCH https://www.excel-easy.com/examples/index-match.html to return lessons and their numbers based on teacher code and class number. If you provide sample file it'll be easier to illustrate on formula.
Thanks for your reply, I was thinking maybe Index and Match would do it, but I need to learn how to use them better.
My concern is if one teacher is teaching 2 year 7 Maths classes, how do i get both classes listed against their name? How do I do a formula that puts all of their classes across the row against their name?
I've attached the file for you to have a look at.
Thanks again for looking at this for me, much appreciated!
Thank you for the file. Could you please clarify how do you map 2021 classes on Class 1, Class 2, etc in Sheet1? Perhaps you may add one-two codes to the tables with manually added desired result.
Another question is on which version of Excel you are? Mainly is it support dynamic arrays or not, other words do you have functions as XLOOKUP, FILTER.
