Forum Discussion
EXCEL FORMULA
Hi All, I have attached a sample data where i have two sheets in Excel. The data which i want from sheet 2 in sheet 1 is cloud classification column in sheet 1 cloud classification column but based...
Hi Kunal_Mehta
In B2
=FILTER(Sheet2!$J$3:$J$9,(Sheet2!$I$3:$I$9=MAXIFS(Sheet2!$I$3:$I$9,Sheet2!$H$3:$H$9,Sheet1!A2))*(Sheet2!$H$3:$H$9=Sheet1!A2))
Hi, don't you think that using XLOOKUP will not necessarily return the value corresponding to the name but may be another value whose name has the same date as that found by MAXIFS ?
don't you think that using XLOOKUP will not necessarily return the value corresponding to the name but may be another value whose name has the same date as that found by MAXIFS ?
TBH I'm not 100% what I suggested will work all the times but have a look to the sample I posted, this seems to work...
(feedback appreciated - Thanks)