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

Error readable from string in D365FO

 Reference class: RetailSyncOrdersSchedulerTask Error readable: private str generateHumanReadableErrorDetail(System.Exception _exception, st...