LOOKUP (Vector) Function Dictionary

Function Dictionary Function Examples Function Categories

LOOKUP (Vector)          
Name Jan Feb Mar
Alan 10 80 97
Bob 20 90 69
Carol 30 100 45
David 40 110 51
Eric 50 120 77
Francis 60 130 28
Gail 70 140 73
      Type a Name in this cell : Eric
      The Feb value for this person is :  120  =LOOKUP(F12,D4:G10,F4:F10)
What Does It Do ?              
This function looks for a piece of information in a list, and then picks an item from
a second range of cells.
The WhatToLookFor should be a single item.
The RangeToLook 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.
No special formatting is needed.
The following example shows how the =LOOKUP() function was used to match a name typed
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.
RangeToLookIn RangeToPickFrom
Alan 5 10 15 20 25 30
David   Type a name : Carol
Eric   Value :  15
Fred  =LOOKUP(G41,C38:C43,E38:J38)
The list of information to be looked through must be sorted in ascending order, otherwise errors
will occur, either as #N/A or incorrect results.


Popular posts from this blog

Tamilnadu SIXTH all books free download, Tamilnadu 6th all books free download

Tamilnadu FIRST STANDARD all books free download, Tamilnadu 1ST STANDARD all books free download