Google Sheets: monthly budget in calendar view

Alright, I have a project I'm trying to drum up for monthly budget stuff. I pull down a monthly transaction history from the bank.
date, desc, category, amount for the 4 fields. That goes into tab 1 per se of the spreadsheet.

But my wife really prefers to see things on a calendar type layout vs just a list. She has a register type book that allows the 30 day span to take 2 pages and you can write in what the charges were per day for whatever categories (on the leftmost column)
I.e.:

	1	2	3	4
Amazon	23.87
Target		45.00
Groceries		50.00
Gas			26.50

etc etc.

A decent amount of extra work to transpose all of the transaction log into writing. So I tried to duplicate the same general look of that register in excel. Obviously not much needed to make a layout like this, but figuring out how to populate it from the transaction list is beyond me.

I was hoping there would be a way to take cell B2 (for the 1st) and have that query the transaction tab, and if the category equals amazon, and the day equals the 1st, it would populate the corresponding charge.
I've seen some examples of array lookups and index match, or the older vlookup. but it's hard for me to see exactly how some of those examples might apply to this type of scenario.

Anybody have a minute to toss out some suggestions if this is even possible?

One caveat I should mention, we're trying to utilize google sheets for the monthly summary stuff so both of us can have easy access. It seems google sheets supports most of the excel options, so the aim of this would be to try and get this going in google sheets, but revert to excel 2016 if needed.

Thank you

Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired results are also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

Please update your profile. I suspect that some members passed on attempting this due to trying to remember how things were done in the 2003 version.
This proposed solution uses only one formula, however it makes some changes to the layout.
The formula that populates the range B3:Z32 on sheet 2 is:

Formula:

Please Login or Register  to view this content.

The range B3:Z32 is custom formatted: #,##0.00_);[Red](#,##0.00);
The values in row 2 are Feb dates custom formatted: d
Some of the categories in column A were modified to match the categories on sheet 1.
The data on sheet 1 is changed to a table. When you are ready to enter a new record go to the last populated cell in the Amount column and press the tab key.
Let us know if you have any questions.