View Single Post
 
Old 01-07-2015, 08:07 AM
Steve81uk Steve81uk is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Jan 2015
Posts: 16
Steve81uk is on a distinguished road
Unhappy I want to use formula to auto update cells with information

Basically, I have spent half the day trying to work out if this is possible, to create a formula to take all the tidy up the titles under one location, I have tried a variety of Match and Index functions, Tried Lookups, only just started getting to grips with the CTRL+SHIFT+ENTER array formula but seem to only get the same result in every cell, not sure if that is right.

anyway I have lost all hope right now, hence why I am on here hoping for some help. please find below a link of what I would like,

https://www.dropbox.com/s/e7feu2fvjz...Help.xlsx?dl=0

Thanks in advance for any help given.

Kind Regards

Steve
Reply With Quote