Which formula to use

Copper Contributor

Hi All,

 

I got 2 separate files.

 

1. Trade creditors with a default account number

  • creditor A = always booked on xxxxx Licences
  • etc etc

2. A file with all the account numbers and in a seperate column the new account number

  • old -- xxxx Licences / new -- yyyy Licences

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.

1 Reply

@Sander1285 Look into using VLOOKUP or XLOOKUP is you r Excel version supports it.