Add error checking to existing VLOOKUP formulas

I've inherited a real beast of a workbook that contains many VLOOKUP formulas. A lot of the time the Lookup Value is not available and so I'm left with an "N/A" return. Instead of manually modifying the VLOOKUPs to contain error checking such as ISNA or ISERROR, I was hoping to be able to highlight all cells on a Sheet, press a magic button, and have all the VLOOKUPs converted to ISNA(VLOOKUP)s.

I'm assuming VBA might be the best way to accomplish this... I would try and write it myself, but I'm pretty short on time. Thanks for any help.

Originally Posted by maw230

I'm assuming VBA might be the best way to accomplish this...

Paste the following code in your relevant vba module and run with the cells you'd like your error check around selected.

Please Login or Register  to view this content.

Let me know if that works for you!

Works perfect! I changed the "" to a 0, so that I could use the cells in calculations. Hopefully this will help me jumpstart my venture back into VBA when the time comes!