Excel formula to get value from the latest/highest day of a month returning errors
Posted on 2011-02-20
In the sheet "monthly" of the attached file I have entered a formula (column b, yellow colourred) that should get the data from the sheet "wdme" at the intersection of the cell values of B1 and An.
An contains month-end-dates, but sheet "wdme" shows several working days of the respective month not necessarily including the last calendar day.
For any reason, my formulas returns either an #N/A error or 0.0%... probably a stupid first school year error again, but I have been unable to find out...
I would be grateful for an amended formula that avoids the error and just gathers the value from the latest/highest day / last that appears in row 1 of sheet wdme of the respective month.