Forum Discussion
Vimal_Gaur
Oct 21, 2023Brass Contributor
Fill values on the basis of Column header and row header
Column Header: Months Row Header: Employee Names Data: Present Days Sheet1: Data Sheet2: Custom Get data from Sheet1 and fill Shee2 with intersecting cell value based on Column Header and Row He...
Patrick2788
Oct 21, 2023Silver Contributor
I've created dynamic items for all relevant ranges in your workbook.
This formula will spill a matrix. No fill handle needed.
=LET(
r, XMATCH(CEmployees, Employees),
c, XMATCH(CDates, DateHeader),
IFNA(INDEX(MonthlyData, r, c), 0)
)
.