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)