#N/A
yes this worked except for CG5 it =0 can this be fixed
"Ms-Exl-Learner" wrote:
=IF(ISNA(INDIRECT("B" &
VLOOKUP(ROW()-4,CP$5:CR$65,3,FALSE))),"",INDIRECT("B" &
VLOOKUP(ROW()-4,CP$5:CR$65,3,FALSE)))
Remember to Click Yes, if this post helps!
--------------------
(Ms-Exl-Learner)
--------------------
"Mike" wrote:
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
|