Is anyone able to help me?
Put simply, I need to combine the VLOOKUP and AVERAGE(OFFSET(range)) functions into one cell formula.
There's a couple of limitations:
1) The interrogating sheet is produced on a daily basis and uses the sheet's date as the key to locating the correct row and cell...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.