I had a hankering it might be MATCH, but didn't know what to do with it. (Not used it before!)
Perfect - thanks David! That's enough for me to work on now! Brill.
Hi all, first post - be nice! :)
I'm trying to pull some data off of multiple sheets which are automatically generated each Sunday. The problem I have, the sheets are 250-285 rows long, and the columns grow every week (with trend information).
If I need to pull a specific bit of data, the...