I am having difficulty creating a reference lookup.
I need to be able to enter a place (which will be listed amongst hundreds in
Column A) and then get back and answer shows the values in the row from where
its found the place name and what column header each relates to

                         Felixstowe   Birmingham   Oldbury    Cannock    Manchester
Abby Wood            100               150            200              250  
         300
Abridge                 110               175            210             300
            350
Beelings                  60                125           185              
260             325
Ipswich                  10                 180           295              
350            400

IF i was to seach for enter "Ipswich" in the search cell i would get the
resluts displayed as
"Felixstowe   Birmingham   Oldbury       Cannock    Manchester
     10                 180           295               350            400"

Is this possible?

Many thanks!!