Blanchetdb
Board Regular
- Joined
- Jul 31, 2018
- Messages
- 161
- Office Version
- 2016
- Platform
- Windows
Hi,
I presently have a vlookup formula in a cell but I need to be able to write in that cell if there is no info returned from the vlookup
present vlookup formula: VLOOKUP(Sheet3!I5,Sheet13!1:3000,6,False)
that formula does not always return info (incomplete info data sheet) so I need to be able to write in the cell the required info. I also need to be able to clear the content of the cell without deleting the formula as the template sheet is reusable.
any help would be appreciated
thank you
Dan
I presently have a vlookup formula in a cell but I need to be able to write in that cell if there is no info returned from the vlookup
present vlookup formula: VLOOKUP(Sheet3!I5,Sheet13!1:3000,6,False)
that formula does not always return info (incomplete info data sheet) so I need to be able to write in the cell the required info. I also need to be able to clear the content of the cell without deleting the formula as the template sheet is reusable.
any help would be appreciated
thank you
Dan