Formula Help

[MrWalsh]

Hi All,

I'm new to the forum in terms of posting but have searched around this forum for years for help with bits on Excel.

I'm hoping for some help in terms of some formula if possible. I'm trying to create a timetable as such. I have a few days as sheets with different students names on and then an overall sheet where I have every student on. I would like to work out how many sessions that each student has to attend but can not work out what formula I would need.

https://www.dropbox.com/s/bvtwtpax2wj1r0y/help.xlsx?dl=0

Thanks in advance.

Jonathan

 

[Finalfight40]

How about:

For day 1

=IFNA(VLOOKUP(B2, 'Day 1'!B:F, 5, 0), 0)

For day 2

=IFNA(VLOOKUP(B2, 'Day 2'!B:F, 5, 0), 0)

 

[MrWalsh]

Thanks so much Finalflight40, works a treat!
Jonathan

 

[Finalfight40]

No problem