Lookup Function

N

Neil Greenough

In Column A, I have the following listed down the column:

Initial
Independent
2
3
4
5
etc etc....

Now in Column B next to these, I have a corresponding monetary value. Now,
My lookup function works for the numbers but it doesn't work for the words
'initial' or 'independent'. Any ideas why? The numbers bring back the
corresponding value perfectly but if I choose 'initial' it bring back a
wrong value.

Here's my function:

=N5*24*LOOKUP(C2,A2:A13,B2:B13)
 
M

Max

From Excel's help for LOOKUP: The values in lookup_vector must be placed in
ascending order: ...,-2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE

so think your list
Initial
Independent
2
3
4
5
Click to expand...
etc

needs to be re-sorted as:
2
3
4
5 etc
Independent
Initial
Click to expand...

An alternative is to use VLOOKUP instead, e.g.:
=VLOOKUP(C2,$A$2:$B$13,2,0)
 
M

Max

An alternative is to use VLOOKUP instead, e.g.:
=VLOOKUP(C2,$A$2:$B$13,2,0)
Click to expand...

Bolted unto your existing function, the above would be:
=N5*24*VLOOKUP(C2,$A$2:$B$13,2,0)
 
Top