Date range and Vlookup Approximate Match Equivilant

[Skyline_TnL]

Hello,

I am having an issue with making an equivalent to the VLOOKUP approximate match in Alteryx.

Formula example: =VLOOKUP(B2,Calendar!A:C,3,TRUE)

B2 = Assigned Date = 8/14/2025

I need it to join the tables together so that I can return the check date of 8/29/2025 dynamically.

Begins	Ends	Check Date	WK #
7/12/2025	7/25/2025	08/01/25	31
7/26/2025	8/8/2025	08/15/25	33
8/9/2025	8/22/2025	08/29/25	35
8/23/2025	9/5/2025	09/12/25	37

I assume there is a formula I just can't wrap my head around it, and I don't know how to join the two data sets together without an exact match on the joins.  

[Yoshiro_Fujimori]

Hi @Skyline_TnL ,

I would APPEND the [Assigned Date] with the date range table and filter with the [Begins] and [Ends] fields as below;

Multi Field Formula

This is to convert the dates to Date Type.

DateTimeParse([_CurrentField_],"%m/%d/%Y")

Filter

[Assigned Date] >= [Begins] AND
[Assigned Date] <= [Ends]

Workflow

Output

Assigned Date	Begins	Ends	Check Date	WK #
2025-08-14	2025-08-09	2025-08-22	2025-08-29	35

I hope this helps. Good luck.

[Peter_Guirguis]

Hey @Skyline_TnL  - one way to attempt this is try the formula tool using a "Between" function. 
results -1 means True and 0 means False.