Hi, Thanks in advance for helping a noob.
Sheet 1 (Summary Sheet)
Sheet 2 (Data Sheet)
Sheet 1: O18 is current month and year (Oct 2020);
Sheet 2: B1:HY1 is months, from 1 to 232;
Sheet 2: B2:HY2 is Month Oct 2020 to Jan 2040).
Sheet 1 Cell G6: I would like this cell to display which month we are at. e.g: if today's date matches Oct 2020, to read 1. If it matches Dec 2020 to read 3... etc etc.
Ive played around with index(match) and also Vlookup, although it does not display the correct information.
Also attempted this (don't laugh):IF(MATCH($O$18,'Lynx 02'!B2:HY2,0),'Lynx 02'!$B1,"")
Bookmarks