if v lookup formula
I have this formula
=IF(VLOOKUP(A26,TUESDAY!$A$5:$AC$124,$P$1,FALSE)=" ","DNP",(VLOOKUP(A26,TUESDAY!$A$5:$AC$124,$P$1,FAL SE)))
What I would like this to do is if there is nothing in the cell it should
put DNP and if there is the numbers 0,1,2,3,4 I want it to put those numbers
in the cell. Can you help me
Thank you Dwalston
|