I am using this formula =XLOOKUP(C16,M2:X2,M3:X10) but like to add 2 more criteria, please help
me with the formula, I wonder if there is any other formula that can be used to retrieve data.
Please see the attached file.
Thank you.
I am using this formula =XLOOKUP(C16,M2:X2,M3:X10) but like to add 2 more criteria, please help
me with the formula, I wonder if there is any other formula that can be used to retrieve data.
Please see the attached file.
Thank you.
here is an example with multiple criteria
https://exceljet.net/formula/xlookup...tiple-criteria
If you find the suggestion or solution helpful, please consider adding reputation to the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks