Index Match Function with a Date

		Microsoft Office Forums > Microsoft Excel > Excel
Index Match Function with a Date

FAQ

Mark Forums Read

Thread Tools

Display Modes

01-07-2023, 09:00 PM

Priyantha Gamini Priyantha Gamini is offline

Windows 10 Index Match Function with a Date

Office 2016

Novice

Join Date: Dec 2022

Posts: 9

Priyantha Gamini is on a distinguished road

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..

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:56 AM.