Thread: #N/A
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default #N/A

I have this formula =INDIRECT("B" & VLOOKUP(ROW()-4,CP$5:CR$65,3,FALSE))
I would like these cells with this formula to read a blank cell instead of
#N/A
These cells read #N/A only until data is entered in other cells is this
possible