$$Excel-Macros$$ Re: How to avoid NA# or remove NA# when there is no value found by vlookup.

2009-02-25 Thread Ashish Jain
Hi Prabhat, Assumption: X denotes a Vlookup formula like this X = VLOOKUP(A1,A:B, 2,0). Solution: Use this formula IF(ISERROR(X),,X) Description: Since #NA denotes the

$$Excel-Macros$$ Re: How to avoid NA# or remove NA# when there is no value found by vlookup.

2009-02-25 Thread Dave Bonallack
Hi, If you have xl2007, you can use the new built-in function: IFERR. Dave. Date: Wed, 25 Feb 2009 09:16:37 -0800 Subject: $$Excel-Macros$$ How to avoid NA# or remove NA# when there is no value found by vlookup. From: prabhat.shrivasta...@gmail.com To: excel-macros@googlegroups.com CC: