I have 2 sheets with multiple tables, Sheet 1 got A1 for Jan. 1, then A7 for Jan. 2, A13 for Jan 3; On Sheet 2 I have same single table. What I wanted to have is, if I input the date Jan. 1 on Sheet2 then it will give me the table for Jan. 1 from Sheet1, if I change it to Jan. 2 then table for Jan. 2 will appear. Please see image attached.
Sheet 1 (Data entry section)
Sheet 2 (Only the date will be changed to have these figures)
If I key in 2-Jan on A1 it will give me the A1 table on Sheet 1.
If I key in 3-Jan on A1 it will give me the A7 table on Sheet1.
Column C auto calculate using this formula:
=IF('Sheet1’!A:A=Sheet2!A3,SUMIF('Sheet1’!A:A=Sheet2!A3,'HKD Entry Sheet1'!B:B),"")
I used this command but I can get only the info from one cell which is A1
=IF('Sheet1'!$A$1=Sheet2!$A$1,'Sheet1'!B3,"")
Please help me with a better formula for this, thanks in advance.
Diagram.jpg
Bookmarks