LOOKUP (Vector)
a second range of cells.
Syntax=LOOKUP(WhatToLookFor,RangeToLookIn,RangeToPickFrom)
The WhatToLookFor should be a single item.
The Range To Look in can be either horizontal or vertical.
The RangeToPickFrom must have the same number of cells in it as the RangeToLookin.
Be careful not to include unnecessary heading in the ranges as these will cause errors.
Formatting
in cell G41 against the list of names in C38:C43. When a match is found the =LOOKUP() then
picks from the second range E38:J38.
If the name Carol is used, the match is made in the third cell of the list of names, and then
the function picks the third cell from the list of values.
will occur, either as #N/A or incorrect results.