Thread: how ??
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pierre Pierre is offline
external usenet poster
 
Posts: 149
Default how ??

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 ???