Index Match Function with a Date

Priyantha Gamini · #1 01-07-2023, 09:00 PM

Quote:

Originally Posted by p45cal

maybe:

Code:

=INDEX(Data!$D$2:$D$13,MATCH(1,(YEAR(Data!$A$2:$A$13)=YEAR($B$3))*(MONTH(Data!$A$2:$A$13)=MONTH($B$3))*(Data!$B$2:$B$13=$B$1),0))

?

This code works after modifying it as below.

=INDEX(Data!$D$2:$D$13,MATCH(1,INDEX((YEAR(Data!$A $2:$A$13)=YEAR($B$3))*(MONTH(Data!$A$2:$A$13)=MONT H($B$3))*(Data!$B$2:$B$13=$B$1),0,1),0))

Thank..

p45cal · #2 01-08-2023, 05:38 AM

Quote:

Originally Posted by Priyantha Gamini

This code works after modifying it as below.

=INDEX(Data!$D$2:$D$13,MATCH(1,INDEX((YEAR(Data!$A $2:$A$13)=YEAR($B$3))*(MONTH(Data!$A$2:$A$13)=MONT H($B$3))*(Data!$B$2:$B$13=$B$1),0,1),0))

That's crazy! Are you using Excel? What version?
Indexing twice is pointless:
2023-01-08_123457.png

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Index and Match Function	mismag	Excel	5	05-29-2019 11:26 AM
Excel - Index and Match Function ,First Second and Third Match	paulzy95	Excel	10	09-29-2016 10:46 PM
Index Match Function across different worksheets	shay_mt	Excel	2	04-27-2015 06:04 AM
Index Match function	jackzha	Excel	5	12-03-2014 12:43 PM
Moving a Index/Match function	FraserKitchell	Excel	2	01-19-2010 09:38 AM