Menu

#N/A

Search this Thread

Previous Post

Next Post

#1

Report Post

Posted to microsoft.public.excel.misc

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

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

All times are GMT +1. The time now is 10:38 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement