MS Excel / VBA help thread

You are reading a single comment by @aggi and its replies. Click here to read the full conversation.

•

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 🤦

•

aggi in reply to @hugo7

It sounds like you just want an xlookup but it's not quite clear. It's definitely going to be something doable if you have an example.

•

hugo7 in reply to @aggi

Cheers.

I'll check our xlookup too.

Just having a bit of a mental blank. It's one of these annoying things where I'm trying to make everything auto update, but actually it's not that big and could be just as easily done semi automatically.

About

@aggi started