Hi hemesh,
Thanks for your reply. Very interesting formula. It didnt do exactly what I need, because I need to return multiple values. But I took the following formula:
and I added your suggestion for the ranges
And it works great! Thanks.
I have another question, if I may. What if I want to do the same thing but only with one criteria that would return results that are on all the sheets. Per example, a table where we can choose one employee and get all the results for this employee trough out the year.
ps: i've tried to translate everything, but my sheets and formulas are in french on my computer. sorry if it make some confusion.
Thanks for your help.
Bookmarks