Index Match Function with a Date

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

01-07-2023, 08:13 AM

Priyantha Gamini Priyantha Gamini is offline

Windows 10 Index Match Function with a Date

Office 2016

Novice

Join Date: Dec 2022

Posts: 9

Quote:

Originally Posted by Pecoflyer

And what is the expected answer in B5 ?

(BTW using entire column/row referencing is bad practice)

I hope to get paid salary for the increment date ( if emloyee incremen date is 2022/10/20, then hope to get 2022 october month paid salary)

Thanks

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 01:40 AM.