Lookup function

[shifty]

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

 

[John Moore]

Hi, Sounds like your looking for an VLOOKUP function ,,, based on Ipswich ,,,
try this ... =VLOOKUP(A1,B1:F10,2,0) .. assuming A1 is your ref point (
Ipswich ) and B1 to F10 is your data range