Formula to find values in table. (various locations)

Evening happy campers,

Been looking at this one too long and im afraid to say its baffled me lol.
See attached, i would like a formula to show me what date & time all groups have the session. (table in blue shows deisred finished result)
I dont believe Vlookup will do it, and i dont have enough experience with Match/index/lookup etc to have a go.

many thanks in advance.
galvinpaddy

Originally Posted by micope21

Hi

N4 =INDEX($E$3:$I$19,MATCH($L4,$B$3:$B$19,0),MATCH($M4,$E$2:$I$2,0)) Then copy down

And if you don't want to see the #N/A then use this instead, same formula, just with an added IFERROR function to it.

Please Login or Register  to view this content.

Thanks all, i will go with Tkowal's suggestion as it include the required search for the date, my sample shows the desired result being the date AND time being shown by the formula, but i thank you all the same for your time & effort to help!!
+1rep all round :D
galvinpaddy