Hi, thank you very much for your help.
I have in about 30 worksheets in 1 workbook. In each worksheet-cell B3, I have expiration dates for materials. I want to create a separate worksheet, lets say worksheet called “About to Expire”, look up all 30 worksheets cell B3, list all the expiration dates that are about to expire within 1 month, or already expired in “About to Expire” worksheet. Also spits out which worksheet that expiration date is coming from.
I have initially tried the formula:
=IFERROR(VLOOKUP( TODAY()+30, Worksheet1:Worksheet30, 2, FALSE ),”error”) but this failed.
I think Vlookup to look up date format is incompatible.. I tried vlookup formula to search the same page but it gives invalid for dates, but it works for words.
Thank you in advance for your help.
By: Philip Kim