Nov 25 2021 05:11 AM
Hi All,
I got 2 separate files.
1. Trade creditors with a default account number
2. A file with all the account numbers and in a seperate column the new account number
In file 1 I would like to see what the new account number will be so I will be able to tell if we are de-activating an account number which could still be usefull.
Nov 25 2021 07:20 AM
@Sander1285 Look into using VLOOKUP or XLOOKUP is you r Excel version supports it.