I have used the following formula to look up the account number in col B and to give me the value of the account number which appears in workbook BR1TB. It gives me a value #N/A.
For eg Acc # 102535 should give me a value of -3470.42
Attached please find sample data
It would be appreciated if someone could assist