Populate Columns

[phillygirl777]

Hello,

I have a list of accounts listed in the left-most column on the Data tab (please see the attached workbook) and the associated amounts by month. I need to create a data load on the Result tab that would list all the amounts associated with each month. I cannot use VB project or macros. Could you please suggest the most reliable approach?

Thank you!!

 

[PaulF]

Results Tab C2 and fill down
=INDEX(Data!$B$2:$F$5,MATCH(Result!A2,Data!$A$2:$A$5,0),MATCH(Result!B2,Data!$B$1:$F$1,0))

 

[phillygirl777]

Results Tab C2 and fill down
=INDEX(Data!$B$2:$F$5,MATCH(Result!A2,Data!$A$2:$A$5,0),MATCH(Result!B2,Data!$B$1:$F$1,0))

Thank you!!!!

 

[PaulF]

You are welcome...

 

[Asheesh]

Since i worked on it...

Put it in C2 and drag it down..

SUMPRODUCT((Data!$B$2:$F$5)*(Data!$A$2:$A$5=Result!$A21)*(Data!$B$1:$F$1=Result!$B21))

 

[Eloise T]

Since it appears as time goes on, you will need to populate below Row 22, you can add the following to PauF's excellent formula to prevent #N/A! errors.
=IFERROR(INDEX(Data!$B$2:$F$5,MATCH(Result!A2,Data!$A$2:$A$5,0),MATCH(Result!B2,Data!$B$1:$F$1,0)),"")
See attached.