VLOOKUP dates that fall within a range

I created a sheet to populate inspection dates by cross referencing (VLOOKUP) the license plate number from the inspection record sheet. The tracking sheet needs to populate dates within a column that represents each month (assume current year).

I was able to return dates based on this formula:

=VLOOKUP([Primary Column]@row, {Plate and Date}, 2, false)

but how do I limit the returned values to only that fall within that month?

Thanks in advance, Yael.

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!