| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
LOOKUP() misses on last lookup
I am having some trouble with LOOKUP()
Sample Data: A B Jim AA Joe AA Jack AA 3 AA Count Billy GG Bobby GG 2 GG Count 5 Grand Count =LOOKUP("GG Count", $B$1:$B$20, $A$1:$A$20) Retrun 5, not 2 as expected =LOOKUP("AA Count", $B$1:$B$20, $A$1:$A$20) Returns 3, as expected What am I doing wrong? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Another way to lookup data | Excel Worksheet Functions | |||
| Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
| Lookup function w/Text and Year | Excel Worksheet Functions | |||
| lookup misses the first entry in table | Excel Worksheet Functions | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Threaded Mode
