Tuesday, August 6, 2024

vlookup in excel

 

  • =VLOOKUP(A2,MDM!$A$2:$A$308971,1,FALSE)

  • Argument 1 -> lookup value
  • Argument 2 -> Table array. Note: if it is different sheet then SheetName!Table array
  • Argument 3 -> Column index to compare
  • Argument 4 -> FALSE (Looking for exact match)

No comments:

Post a Comment

Using SysOperationSandbox::callStaticMethod Sample in D365FO X++

 SysOperationSandbox::callStaticMethod(classnum(Classnum(<Class name>)), staticMethodStr(<Class name>, <Class static method n...