Jeffrey, my apologies for my simple nature this evening, I can't seem to get it to work on my actual sheet...

=IFERROR(HLOOKUP($J$9,Capacity!$A$29:$E$30,ROW(D9),0),"")

The code for 'today' is in J9, the table is in a sheet called Capacity and ranges from A29 to E30 in the format of the days on top with the numbers on the bottom similar to the workbook I uploaded earlier. However I don't really get what the 'ROW(D9)' bit means. Where should I focus this? At the moment it's not returning any data.