What results and how do you want to return it?
Do you want a count of the items that include the string "axe" in column A?
=COUNTIF(A1:A5,"*axe*")

Do you want a sum of Column B where column A includes the string "axe"?
=SUMIF(A1:A5,"*axe*",B1:B5)

or are you looking to filter out everything that does not include the string
"axe"? If so, then you'd probably have to use a custom filter.

HTH,
Paul


--

"pierre" wrote in message
...
HELLO GUYS....HELP
given:

A B
1 axe red 10
2 axe blue 20
3 axe green 30
4 axe pink 40
5 table 50

what should i do if i would want to type in cell C1 (as a search string)
the word "AXE" in order to get ALL results about it ??? vlookup ?? or
index(...,match(...)?? or aother ways ???