$$Excel-Macros$$ Re: How to avoid NA# or remove NA# when there is no value found by vlookup.
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.
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: