Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Simple lookup
I want to look at a fixed list of account numbers and check if a given number
is in that list. I'd prefer to do that without sorting on the list,a dn VLOOKUP seems like overkill because I don't need to know any data associated with the lookup number, I just need to know if its in the list. Thanks |
#2
|
|||
|
|||
Something like ...
=IF(ISNA(MATCH(A1,B1:B10,0)),"Not Found", "Found") Enter the above formula into a cell (say C1) Enter some text in A1 If the matching text is found in cells B1 ~ B10, C1 will show "Found" "Bill" wrote in message ... I want to look at a fixed list of account numbers and check if a given number is in that list. I'd prefer to do that without sorting on the list,a dn VLOOKUP seems like overkill because I don't need to know any data associated with the lookup number, I just need to know if its in the list. Thanks |
#3
|
|||
|
|||
Bill,
Take a look at Excel's COUNTIF worksheet function in the on-line help. For example, this formula returns the number of times the number 6 appears in the range C1:C6 . . . =COUNTIF(C1:C6,"6") ---- Regards, John Mansfield http://www.pdbook.com "Bill" wrote: I want to look at a fixed list of account numbers and check if a given number is in that list. I'd prefer to do that without sorting on the list,a dn VLOOKUP seems like overkill because I don't need to know any data associated with the lookup number, I just need to know if its in the list. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Lookup Lookup | Excel Worksheet Functions | |||
Lookup Function Problem | Excel Discussion (Misc queries) | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
Excel Lookup Functions | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |