Forum Discussion
Humphriesre
Aug 04, 2022Copper Contributor
Need a formula to output specific information
I have a set of data that is sorted horizontally by month and vertically by item. I am trying to create a formula that will look for a specific month and then output data from a specific cell base...
Harun24HR
Aug 05, 2022Bronze Contributor
You can use XLOOKUP() and FILTER() to gain desired result. See the attached file.
=XLOOKUP(C14,C5:C7,FILTER(D5:F7,D4:F4=D13))