View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
droper droper is offline
external usenet poster
 
Posts: 9
Default search in excel 2000 (9.0.2720)

We have a filing system which has the file name in col A, and keywords in col
B. For example "Aa taxis" in A1, then "transport, travel, cars" in column B1.
Then"Best travel company" in A2, then "Transport, travel, taxis" in B2.
Then "Bonapart Restaurant" in A3, then "entertaining, eating" in B3.
I want to key in "Taxi" then have excel retrieve A1,A2,B1 & B2 & any other
cells which contain the word "Taxi".
Please bear in mind that I am not very technical, so for answers to be of
any help they need to be "Idiot proof".
(Did I just call myself an idiot?)
Thanks for any help....David Roper