Here's my formula:
=IFERROR(((VLOOKUP($D$2,UOS!$A$18:$AC$31,5))/30)*$G$2,"")
The $D$2
field is populated with =Text(c1,"mmmm")
When I use this formula and $D$2
is January, February, March, May, June, July, September, October or November - the formula works. But when $D$2
is April, August, or December it doesn't work.
The table array is all formatted the same for the month.
The error that I get if I remove the IFERROR is #value
I have tried everything that I can think of - formatting, direct key of month into D2, etc.
How can I resolve this?