Hi,
I have two identical workbooks; in one of them the following formula works but in another it returns the #N/A error and I can't figure out why. I appreciate this is probably a difficult one to answer without seeing the files but they conatin sensitive info so I can't share them. I have...