i am creating a business day list to pull figures from a table, im using vlookup for this and it is returning public holidays in a #NA value as it cant find the values in the table, is there any way how i can just make it return a 0 value instead as the #NA is mucking up proceeding formulas...
be much help if you can provide assistance...
cheers
Bookmarks