#N/A

F

Frank Kabel

Hi
try
=IF(ISNA(VLOOKUP(...)),"No data",VLOOKUP(...))
-----Original Message-----
Hi,

I'm using a VLOOKUP formula that looks for a value in one
Click to expand...
sheet and, if it finds it, putting the value in another
sheet. This works fine and as I am expecting I get some
N/A errors when the value isn't found. I would like to
know if there is a way of formulating a replacement for
this N/A eg., changing it to 'No forecast data'
 
Top