Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup function
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!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup function
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 "shifty" wrote: 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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup function (i think) | Excel Worksheet Functions | |||
how to combine an IF Function with a lookup function to determine | Excel Worksheet Functions | |||
How to use lookup Function in vba | Excel Discussion (Misc queries) | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
lookup function? | Excel Worksheet Functions |