I have a formula which gives a #n/a in the cell :
=VLOOKUP(A1,B14:C29,2,FALSE)
In order not to show #n/a, I've edited the cell and changed it to:
=IF(ISERROR(VLOOKUP(A1,B14:C29,2,FALSE)),0,VLOOKUP (A1,B14:C29,2,FALSE))
Is there a way to create a macro so that I don't have to edit the
formula every time. In other words, the macro will do all the editing
for me.
Thanks in advance for your help!
--
Tang123
------------------------------------------------------------------------
Tang123's Profile:
http://www.excelforum.com/member.php...o&userid=27846
View this thread:
http://www.excelforum.com/showthread...hreadid=473577