Forum Discussion

Copper Contributor

Apr 18, 2023

Solved

look for a specific date from table of ranges of dates

Hello everyone and thanks from advanced. I need to look for a specific date (receiving date) from other table with ranges of dates (each month divided for 2) and take the value of the cell output ce...

excel

Formulas and Functions

Lorenzo
Apr 18, 2023
Hi Asaf_AM
Alternatively with Excel 2021/365
in G2
=XLOOKUP(F3, Table1[From], Table1[Lead Time], "no match", -1)

Lorenzo

Silver Contributor

Apr 18, 2023

Hi Asaf_AM

Alternatively with Excel 2021/365

in G2

=XLOOKUP(F3, Table1[From], Table1[Lead Time], "no match", -1)

Asaf_AM

Copper Contributor

Apr 18, 2023

Lorenzo Worked perfect! thanks to you all

Lorenzo
Silver Contributor
Apr 18, 2023
Asaf_AM

Glad we could help & you have a solution
Next time(s) don't miss the 'Mark as solution' link at the bottom of the replies you get - HansVogelaar was kind enough to do it on your behalf but has more important things to do as a key contributor to this forum - Thanks & nice EOD