BrdgBldr
asked on
Excel formula to get value from the latest/highest day of a month returning errors
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.
Thanks.
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.
Thanks.
No attachment :)
ASKER
Ok, Patrick, without attachment, 125 points is a bit meager... ;-)
ee14.xls
ee14.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks a lot Barry!