Forum Discussion
Solved
XLOOPUP with multiple filter function
Hoping someone can help me on this, I would like to have a formula in E3 downwards in the data tab that will pick from tab 3.16 a value like in column C but for a year indicated in cell E1. In colum...
Lycias Hi, I have tried to solve your query using XLOOKUP itself. Just joined the code and 2017 in lookup value. And also joined both the LOOKUP ARRAYS.
Below is the file attached. Please let me know if this solves your query.
Lycias Hi, I have tried to solve your query using XLOOKUP itself. Just joined the code and 2017 in lookup value. And also joined both the LOOKUP ARRAYS.
Below is the file attached. Please let me know if this solves your query.
Thanks nidhiachhaa9 , it worked. Thaks a lot!
Lycias
Lycias