HI,
I'm having a brain freeze.. and may not have tackled this in the best way.. but here is my issue.
I have a Nested If that is testing for 2 cells being blank and if they are then it returns blank... (i know I could use ISBLANK).. but my issue is the IF statement further in...
=IF(AND(AH4="",BH4=""),"",IF(FL4>74.9,"A2","AS"))
Cell FL4 contains a Formula... =IFERROR((VLOOKUP(BH4,A2_Pts,2,1)),"")
So Excel appears to be stating that the Cell contains a number greater than 74.9... as it is a formula..
The Vlookup is pulling a range of values depending upon what is entered on another cell..
Any help would be appreciated..
Thanks
Dave
Bookmarks