I am wanting to perform a lookup but want to add three column indexes together
ie. VLOOKUP($A7,$C$15:$CD$74,15) would give me the result in column 15 of the array but I want the sum of columns 15,16 & 17 as the result.
Anyone know a crafty way around it without creating a separate column for the sum of 15,16 & 17
ie. VLOOKUP($A7,$C$15:$CD$74,15) would give me the result in column 15 of the array but I want the sum of columns 15,16 & 17 as the result.
Anyone know a crafty way around it without creating a separate column for the sum of 15,16 & 17