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

Replaces the value of the specified dimension attribute from source to target in D365FO

Replaces the value of the specified dimension attribute from source to target => LedgerDimensionDefaultFacade::serviceReplaceAttributeVal...