looking for a formula that will evaluate all dates from column D on worksheet 2 if all dates from D3:D10 are equal to D2 then set the value of cell C4 on worksheet 1 to ALL else if the dates do not equal D2 then match the values from column B on worksheet 2 where column D dates do equal then concatenate the values from column B to cell C4 on worksheet 1.
A sample file is attached with an illustration of the desired outcome. Thanks for checking this out!
The tabs in your workbook are not named "worksheet 1" and "work sheet 2". This makes it very difficulty to match the info you give to the data in the workbook.
Trish in Oz
-------------
A problem well defined is a puzzle half solved
If you attach a sample of your workbook it will be easier to find a solution.Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
http://www.excelforum.com/faq.php?fa...b3_attachments
Thank you for catching the tab naming convention disconnect. I've uploaded a revised version that will match the original problem statement.
Many thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks