Vertical lookup; searches for a key in the first column of a range and returns a value from another column in the same row.
=VLOOKUP("Orange", A2:C100, 3, FALSE) finds "Orange" in A2:A100 and returns the corresponding value from column C.
