LOOKUP(value,vector1[,vector2])
LOOKUP function finds the row index of value in vector1 and returns the contents of vector2 at that row index. Alternatively a single array can be used for vector1. If the area is longer than it is wide then the sense of the search is rotated.