INDEX & MATCH - Trying to pull information from two worksheets based on matching dates

Hi Wrayden. Welcome to the forum.

Please upload a sample workbook. It saves having to retype data and provides context. We can also see what formulas you've attempted to better interpret what you've described.

If you are not familiar with how to do this:

To attach a file to your post,

• be sure to desensitize the data
• click “Go Advanced” (next to Post Quick Reply – bottom right),
• scroll down until you see “Manage Attachments”, click that,
• click “Browse”.
• select your file(s)
• click “Upload”
• click “Close window”
• click “Submit Reply”

The file name will appear at the bottom of your reply.

Try putting it in a *.zip file. The size limit is greater for those.

Originally Posted by Wrayden

I have tried zipping the file at around 4KB and the upload keeps failing. Any ideas?

What are the upload steps you are following?

What exactly does "upload keeps failing" mean ... ie what is the forum response ... error msg ... other?

Thank you for the quick reply. The message reads:

Manage Attachments
Upload Errors
DesensitizedOperatingMatrix.zip - Upload of file failed.

There doesn't appear to offer a reason.

I am following the steps offered in a previous reply (see above).

Hang on. I'll see if we can get help.

Normally it's best to attach here, but as you are having problems, Google Drive will be fine (unless anyone helping is unable to access it).

The .zip file will not upload here for me, either, but I was able to access it on Google Drive.

I must say I am very impressed with the instant responses to my inquires. I have learned so much reviewing previous posts, but I am enjoying the open and kind assistance everyone has directly given me. Thank you.

That worked.

Ali, thanks for answering the "call".

Wrayden thank you. That helped immensely.

All I was able to come up with (at least so far) is this array entered monster.

In case you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

In H4 and filled down.

Formula:

Please Login or Register  to view this content.

I put some "fake" numbers into July to test. It works.

Array formulas are resource hungry. The size of your workbook suggests other calculations will be in play. Please let us know if performance becomes an issue.

PS I noticed a rather large number of OFFSET formulas in 'CORE ANNUAL RAW DATA'. Normally OFFSET isn't a problem, but when there are that many they too can slow a workbook down. If you are not aware of it OFFSET is a volatile function. They and all their dependents recalculate at the slightest non related edit of data. There are alternatives if that gets to be an issue.

You are welcome glad to help. Thank you for the kind words.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

If you are still here that formula can be shortened. Still array entered.

Formula:

Please Login or Register  to view this content.

With the file closed,
Windows Explorer
Right click the workbook
Send to... Compressed (zipped) folder

Tje .zip will be in the same folder

Thank you for that Ben.