Forum Discussion
Solved
XLOOKUP Support - (Across Tabs)
Hello - In the below screen shots, I've been trying to create an XLOOKUP (within an XLOOKUP) to pull across details from 2021 & 2022 into the Outputs tab. I then want to subtract the differe...
Perhaps
=INDEX('2022'!$B$2:$E$4, MATCH($A2, '2022'!$A$2:$A$4, 0), MATCH(B$1, '2022'!$B$1:$E$1, 0))-INDEX('2021'!$B$2:$E$4, MATCH($A2, '2021'!$A$2:$A$4, 0), MATCH(B$1, '2021'!$B$1:$E$1, 0))
Perhaps
=INDEX('2022'!$B$2:$E$4, MATCH($A2, '2022'!$A$2:$A$4, 0), MATCH(B$1, '2022'!$B$1:$E$1, 0))-INDEX('2021'!$B$2:$E$4, MATCH($A2, '2021'!$A$2:$A$4, 0), MATCH(B$1, '2021'!$B$1:$E$1, 0))