View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dwalston dwalston is offline
external usenet poster
 
Posts: 3
Default 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