MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Joe C on October 03, 2001 12:36 PM

Im using VLookup on a big table
Occasionally I get a Error message #N/A
How do I write an if statement to turn that into a 0?

Posted by Barrie Davidson on October 03, 2001 12:41 PM

=IF(ISNA(your vlookup statement),0,your vlookup statement)

BarrieBarrie Davidson

Posted by Joe C on October 04, 2001 5:00 AM

Thanks Again