Which formula to use

%3CLINGO-SUB%20id%3D%22lingo-sub-3005799%22%20slang%3D%22en-US%22%3EWhich%20formula%20to%20use%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3005799%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20got%202%20separate%20files.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20Trade%20creditors%20with%20a%20default%20account%20number%3C%2FP%3E%3CUL%3E%3CLI%3Ecreditor%20A%20%3D%20always%20booked%20on%20xxxxx%20Licences%3C%2FLI%3E%3CLI%3Eetc%20etc%3C%2FLI%3E%3C%2FUL%3E%3CP%3E2.%20A%20file%20with%20all%20the%20account%20numbers%20and%20in%20a%20seperate%20column%20the%20new%20account%20number%3C%2FP%3E%3CUL%3E%3CLI%3Eold%20--%20xxxx%20Licences%20%2F%20new%20--%20yyyy%20Licences%3C%2FLI%3E%3C%2FUL%3E%3CP%3EIn%20file%201%20I%20would%20like%20to%20see%20what%20the%20new%20account%20number%20will%20be%20so%20I%20will%20be%20able%20to%20tell%20if%20we%20are%20de-activating%20an%20account%20number%20which%20could%20still%20be%20usefull.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3005799%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3006174%22%20slang%3D%22en-US%22%3ERe%3A%20Which%20formula%20to%20use%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3006174%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1229598%22%20target%3D%22_blank%22%3E%40Sander1285%3C%2FA%3E%26nbsp%3BLook%20into%20using%20VLOOKUP%20or%20XLOOKUP%20is%20you%20r%20Excel%20version%20supports%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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.