Lookup Reference Functions MSOfficeExcel 2007 Tutorial

  1. Home
  2. MSOfficeExcel 2007 Tutorial
  3. Lookup Reference Functions
  4. LOOKUP looks up values from a one-row or one-column range or an array
=LOOKUP(3,A2:A6,B2:B6) looks up 3 in column A, and returns the value  from column B that's in the same row

Input the formula: =LOOKUP(3,A2:A6,B2:B6). Press Enter to get the result.