@Sgnair
Here's a reference to a helpful source on resolving the #VALUE error message.
If that's not helpful in resolving your situation, then please come back with a more complete description and, ideally, posting a copy of the spreadsheet in question on OneDrive or GoogleDrive (just making sure there's no confidential information contained in it). Paste a link here granting access with editing privileges.
