You are reading a single comment by @hugo7 and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
aggi
@hugo7
I'm trying to create a table in summary page tab. The aim is to show, amongst other things, this month's figures for different teams.
I get this month in a cell with =text(today(), "mmm")
What I am struggling with is how to work out is how I then source the correct figures based on that date.I am after a formula that says if the text in cell range D21:L21 = C2 then C3 = the corresponding figure in the range D23:L23...if that makes sense?Lookup 🤦