• Looks up text that contain ‘UP’

  • Finds irrelevant records

  • Used to look in a single row or column and find a value from the same position in a second row or column

  • All of above


Used to look in a single row or column and find a value from the same position in a second row or column

New Questions