Simple lookup

B

Bill

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
 
S

Stevie_mac

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"
 
J

John Mansfield

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")
 
Top