| 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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
LOOKUP() misses on last lookup
melchman Wrote: 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? Hi I copied and pasted your data and formulas, they both seem to work for me -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=527332 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
LOOKUP() misses on last lookup
Tried replicating your problem unsuccessfully. The values returned in my test matched your original expectations. Perhaps you should post your cut-down file. -- John James ------------------------------------------------------------------------ John James's Profile: http://www.excelforum.com/member.php...o&userid=32690 View this thread: http://www.excelforum.com/showthread...hreadid=527332 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
LOOKUP() misses on last lookup
I consolidated the file to 50 entries and reformed the LOOKUP()s +-------------------------------------------------------------------+ |Filename: LookupBook.zip | |Download: http://www.excelforum.com/attachment.php?postid=4583 | +-------------------------------------------------------------------+ -- melchman ------------------------------------------------------------------------ melchman's Profile: http://www.excelforum.com/member.php...o&userid=33159 View this thread: http://www.excelforum.com/showthread...hreadid=527332 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
LOOKUP() misses on last lookup
Try this I get nine instead of Fourty Nine =COUNTIF($B$100:$B$153,"UNDERWRITERS") -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=527332 |
| Reply |
| 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 | |||
Linear Mode
