Hi all, what an excellent forum.
I have a relatively basic query which I will try to explain as clearly as I can.
I have some workbooks in a spreadsheet that contain price lists for car journeys, sorted by postcodes (Passenger Car Comparison workbook).
I want to compare these lists in a separate workbook called Search Tool, where I can use a drop down to choose a postcode and then the price for each one is compared in the same row. I have created a postcode list but I can't work out how to link the data to this list. Do I need Index and Match or Hlookup? If anyone could help I would be eternally grateful!
I have a link to the spreadsheet here:
https://onedrive.live.com/redir?resid=79B35E2AC1483838!190
I have a relatively basic query which I will try to explain as clearly as I can.
I have some workbooks in a spreadsheet that contain price lists for car journeys, sorted by postcodes (Passenger Car Comparison workbook).
I want to compare these lists in a separate workbook called Search Tool, where I can use a drop down to choose a postcode and then the price for each one is compared in the same row. I have created a postcode list but I can't work out how to link the data to this list. Do I need Index and Match or Hlookup? If anyone could help I would be eternally grateful!
I have a link to the spreadsheet here:
https://onedrive.live.com/redir?resid=79B35E2AC1483838!190