A better way then multi sheet sumif

[Joe C]

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.

 

[Aladin Akyurek]

FY07Grid!$G$14:$S$578 is a multi-column range. Which column is RwGrd!G23 supposed to match and from which column a numeric value must be returned?

 

[Joe C]

That is not know the way the 2 datasets vary the unique match I need for 07 data may be anywhere in the array. The Sumif works but it takkes a long time.

 

[Aladin Akyurek]

That is not know the way the 2 datasets vary the unique match I need for 07 data may be anywhere in the array. The Sumif works but it takkes a long time.

I think the match range must be every Nth column. Given such a layout and no clue in which column to look, a SumIf formula is the best choice.

 

[Joe C]

Thanks for the help.
I thought that might be the answer, but was hoping there was something less time consuming.