Hi,
I hope the good people on here are able to help. Im tearing my hair out :-(
I have a resource tracker which has a dashboard to pull data using a SUMPRODUCT from another sheet. If the data range on the sheet has a vlook which is blank, then the formula displays #N/A. This then causes the...