Trying to obtain Value that falls in a Date Range

		Microsoft Office Forums > Microsoft Excel > Excel
Trying to obtain Value that falls in a Date Range

FAQ

Thread Tools

Display Modes

07-08-2023, 10:58 PM

ArviLaanemets ArviLaanemets is offline

Trying to obtain Value that falls in a Date Range

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 961

I'd create an UDF (user defined function) in VBA, which returns a latest value from Rate column from all records for certain SupplierID/Supplier value.
Then you simply use the formula in cell you want the rate returned. Something like:

Code:

=UdfName(RateSourceRange, RateDateSourceRange, YourDate, SupplierSourceRange, YourSupplier)

I myself can't help with code for this, as I haven't access to MS Office for next 3 weeks!

Tags

date range compare rates

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find if Date range falls within another range	Triadragon	Excel	3	05-02-2016 11:48 AM
Check if a Date falls within a date range	OTPM	Excel	7	02-03-2016 09:11 PM
Filter by a Month that falls within a date range	MattG1225	Excel	2	12-03-2015 07:44 AM
HELP: Return a value with a date that falls between two other dates	hionman	Excel	5	11-12-2014 09:56 AM
How to obtain maximum value of an excel column with a large range?	sirkay	Excel	4	02-23-2014 08:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:45 AM.