Forum Discussion
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 difference (within the xlookup formula) between 2021 and 2022 only showing the result.
Within the below screen shot for "Tab: Output" the first part of the formula doesn't seem to work. Any help would be appreciated! Thank you!
Tab: Output
Tab: 2022
Tab: 2021
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))
1 Reply
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))