Lookup() is intended for one-column operations: check out VLOOKUP().
It will do the job for you.