VLookup
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
Barrie,
Thanks Again
