Forum Discussion
Excel Formula
Hi,
I'm trying to figure out which formula (if any) to use in my workbook to make it more automated. I am needing to have a formula in worksheet 4, that will go to worksheet 1, locate the word "Thursday" in column B and return the corresponding date listed in column A. For more context, worksheet 1 has information for daily testing and worksheet 4 is a report that requires specific information for Thursdays only. I've been able to automate everything except for pulling the dates from worksheet 1. I've tried VLOOKUP, XLOOKUP, IF, IFS and I just can't figure it out, as well as spending many hours trying to research which formula(s) to use. Please let me know if more information is needed.
1 Reply
Yes indeed; more information would be helpful. It's probably not a difficult thing to resolve, but seeing the actual workbook (or a fully representative mockup, if the actual contains confidential info) would make it a lot easier to help you.
That said, assuming that there probably are multiple "Thursday" entries on Sheet 1, and multiple corresponding dates, you might find the FILTER function does what you want. If you're comfortable playing with new functions, have at it yourself. That hyperlink provides some good examples. You might also find one of these YouTube videos to be useful.
But if help is still needed, come back and post a sample of your workbook, not an image, an actual Excel file.
