I have a matrix of data on which I need to do some look up and sum. I think I need a combination of three formulas and just wondered if there is a simple way of doing this. I need to look up the something in the first row of data to find the correct column (HLOOKUP), then a look up on the first column of data to find the correct row of rows and then sum the relevant rows (SUMIF, VLOOKUP). Hope this makes sense, any help would be greatly appreciated.