1. Row Return: Index Match query
I am trying to return the date (Column A3:A12) based on the name E.g. D2 being found in the table (M3:AD12). I can't get the index matching to work as i have for the time (e.g. D13) corresponding to the name D2.
2. I have a Horizontal offset drop down in M3:AD12 however it will only find the first 5 (D2:H2) of D2:L2. I am currently using the following formula as for some reason it only works with i extend it to Q2 albeit doesn't return anything beyond H2
=OFFSET($D$2,0,0,1, COUNT($D$2:$Q$2))
I have attached the spreadsheet for ease of explanation!
Thanks to any and all for help.
Bookmarks