Lookup Formula with 2 variable

[rizmomin]

Hello:
Please refer to attached file.

I need formula in cell C3,E3,G3,I3 in Sheet1 from data for the store and month in sheet2.
I have manually shown the values in sheet1

Let me know if you have any questions.
Thanks.

Riz

[Glenn Kennedy]

Shhet 1, C3, copied across:

=IFERROR(INDEX(Sheet2!$C$4:$O$15,MATCH(Sheet1!$A$1,Sheet2!$A$4:$A$15,0),MATCH(Sheet1!C$1,Sheet2!$C$2:$O$2,0)),"")

But... delete the leading space in sheet1 e1.

[rizmomin]

Hello Glenn:

Thanks a lot

Riz

[Glenn Kennedy]

No problem.. As a matter of interest... which Georgia are you in: the one in the US or the one in the Caucasian region...? I've never been to GA, USA (so far...) but have been in Tblisi in the Republic of Georgia, a great place...

[AlKey]

Enter in C3 and copy across and down
For Income:

Please Login or Register  to view this content.

For Payroll

Please Login or Register  to view this content.

Please see attached file

[rizmomin]

Hello Glenn:

I am in Georgia, USA.
Would love to meet if you are around.

I need 1 more favor.
Please refer to attached, which i forot to mentioned.
I have 2 Catogory in attached file, Income and PAyroll.
Need formula to pull Payroll Numbers

Please let me know if you have any questions.
Thanks.

Riz

[Glenn Kennedy]

Have you attached the correct file??

[rizmomin]

Hello Glenn:
Sorry,
Please refer to attached file.
Let me know if you have any questions.
Thanks.

RIZ

[rizmomin]

Hello Guys:

I have resolved ...Please refer to attached file.


Let me know if you have any questions.
Thanks.