Create 2D Matrix of Values From Data in 3 Columns Using Lookups

[Jbertie]

Hi there,

I am looking to essentially create a 2D matrix of of revenue information, where the revenue value in column 1 will be plotted in the matrix depending on the fiscal year in column 2 and the fiscal quarter in column 3.

I have attached a sample worksheet snapshot below. You'll not in the FY21 section of the matrix, I have FY21 in the row above each quarter (Q1-Q4), while in the FY22 section, I have only included "FY22" above Q1. I would prefer not to have the fiscal year in each column above the quarters (ie. the layout of FY22), if possible, but if not I am fine with the layout of FY21.

I would prefer a non-pivot table solution if possible.

Thank you in advance!

 

[Fluff]

Hi & welcome to MrExcel.
Is this what you want

+Fluff New.xlsm
	A	B	C	D	E	F	G
1				FY21	FY21	FY21	FY21
2				Q1	Q2	Q3	Q4
3	1	FY21	Q1	1
4	2	FY21	Q2		2
5	3	FY21	Q3			3
6	4	FY21	Q4				4
7	5	FY22	Q2
8	6	FY22	Q4
9	7	FY22	Q3
10	8	FY21	Q1	8
11	9	FY22	Q1
12	10	FY22	Q4
13	11	FY22	Q2
Data

Cell Formulas
Range	Formula
D3:G13	D3	=IF(AND($B3=D$1,$C3=D$2),$A3,"")