I am using this formula
looks for the sheet based on A5
It finds the max number from the sheet in Column D
This is what i would like to do please....
found sheet - Column A has dates in this format yyyy.mm.dd
I would like to enter a date in a cell (say for example
AA5 on main sheet)
Can the formula above be adapted to:
Look for sheet based on A5
Look at date entered in AA5
use Vllookup to find row containing date in AA5 (making table range the ENTIRE SHEET found based on A5)
Return value from Column D
Thanks in advance... Hope this is possible...