Forum Discussion
Solved
nested xlookup
Hello My input data is my desired output is how to achieve this result, basically, i need to get the values for whatever date i enter in the column header. it needs to pull t...
See the attached version.
See the attached version.
thank you. Xlookup also worked now. they trick lies in applying DATEVALUE. i saw that in your formula.
=XLOOKUP(DATEVALUE(Table25[[#Headers],[06-Aug-24]]),Table1[Date],XLOOKUP([@Report],Table1[[#Headers],[opening balance]:[balance]],Table1[[opening balance]:[balance]],"",0,1))
i entered this formula in B2 of report table. worked like magic.
thank you.
The headers of a table are always text, even if they look like dates. That's why you need DATEVALUE.