![]() |
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!! |
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!! |
All times are GMT +1. The time now is 02:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com