This site is a treasure trove of information. I did a search for VLOOKUP Error, and this is the first thing I found.
When I have the Vlookup formula and the field where I have the data to lookup is empty I get a sign with a number symbol and N/A, how can I tell excel not to show me this when the field where I type the information that I want to look is empty?. I want all the formulas fields to show nothing.
Last edited by shg; May 12th, 2007 at 06:16. Reason: Edit title
There are five possible answers at the bottom of the page!
Although none of these actually addresses the specific question posed. Of course you could use ISNA or ISERROR but if the aim is only to return blank when the lookup value is blank, which is what was asked, then the example I posted would sufficeOriginally Posted by royUK
I wasn't suggesting anything wrong with your answer, just pointing out that there were answers to look at generated below the question!Originally Posted by daddylonglegs
There are currently 2 users browsing this thread. (0 members and 2 guests)