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.
Sincerely,
Philip Kim
By: Philip Kim
I am really grateful to the owner of this web site who has shared this wonderful piece of writing at at this place.
I have to thank you for the efforts you have put in writing this blog.
I really hope to see the same high-grade content from you later on as well.
In fact, your creative writing abilities has
inspired me to get my very own blog now 😉
I discovered your blog web site on google and examine a number of of your early posts. Proceed to maintain up the superb operate. I just extra up your RSS feed to my MSN News Reader. Searching for forward to reading more from you in a while!…