I have data in 2 formats,
I am using a sumif to find the where a partuicular unique match is on one sheet and then pulling the data from another identically formated sheet.
=RwPePas!G23*SUMIF(FY07Grid!$G$14:$S$578,RwGrd!G23,'FY07'!$G$14:$S$578)
So basically the
FY07Grid sheets is a breakdown of which cell is storing what data for 07.
RwGrd sheet is a breadown of which cell is storing what data for 06.
RwPePas is the percentage of the 07 data I need to pull for the cells result.
My sumif is actually always just looking up 1 unique data point. Is there a better way to write it, I wasnt sure if index or match would work because I am actually pulling number from another sheet. Also the actual match may be anywhere in the array. So trying Vlookup will not work.
I am using a sumif to find the where a partuicular unique match is on one sheet and then pulling the data from another identically formated sheet.
=RwPePas!G23*SUMIF(FY07Grid!$G$14:$S$578,RwGrd!G23,'FY07'!$G$14:$S$578)
So basically the
FY07Grid sheets is a breakdown of which cell is storing what data for 07.
RwGrd sheet is a breadown of which cell is storing what data for 06.
RwPePas is the percentage of the 07 data I need to pull for the cells result.
My sumif is actually always just looking up 1 unique data point. Is there a better way to write it, I wasnt sure if index or match would work because I am actually pulling number from another sheet. Also the actual match may be anywhere in the array. So trying Vlookup will not work.