I have a dataset on sheet 2 with a new group heading in column A and row 1,18,34,50,64 etc. I want to use Hlookup, but dont want to change the refrence each time. Also I have listed these group headings in sheet1 columnA and the data I will be search will be placed in column B of sheet 1 right next to the name. Can anyone suggest me a way to automate this so that I write one formulla and copy it down for the entire set