Forum Discussion

Asaf_AM's avatar
Asaf_AM
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's avatar
    Lorenzo
    Apr 18, 2023

    Hi Asaf_AM 

    Alternatively with Excel 2021/365

    in G2

    =XLOOKUP(F3, Table1[From], Table1[Lead Time], "no match", -1)
HansVogelaar's avatar
HansVogelaar
MVP
Apr 18, 2023

Asaf_AM 

Let's say that the table with the ranges is on a sheet named Data in A2:D11 (with headers in row 1).

And the receiving dates are in A2 and down on another sheet.

Enter the following formula in B2, then fill down:

 

=IFERROR(VLOOKUP(A2,Data!$B$2:$D$11,3),"")

 

Resources