VLOOKUP, or Vertical Lookup, finds a value in a vertical list and returns the corresponding value in an adjacent vertical list. Get the year of hurricane Ike by typing this formula into the field below: =VLOOKUP("Ike", A1:B4, 2, 0)