vlookup + month + year

  1. weiser386

    Hyperlinks in Macros??? Maybe easier way?

    Good Afternoon, I would imagine this is a really easy question for most of you however for me it is not. :mad: So here is my issue, I have a worksheet that has a years worth of production data that is nicely lined out with the dates included. I have two buttons at the top of the page, one...
    • weiser386
    • Thread
    • hide cells hyperlink unhide cells vlookup + month + year
    • Replies: 3
    • Forum: Excel Questions
  2. M

    Help auto fill sum of product sales by date... Please!!!

    I have three products that I need to fill a time line for. How do I do this? <colgroup><col span="16"><col><col span="4"></colgroup><tbody> Date Sprockets Springs Gizmos 1/2/2001 698 156 875 1/2/2001 654 159 446 1/2/2001 126...
    • MrMumbles
    • Thread
    • aggregate date filter sort sumif vlookup + month + year
    • Replies: 4
    • Forum: Excel Questions
  3. ortmll

    VLOOKUP MONTH & YEAR formula

    I need to update my formula so that it captures the month & year of a date. Here is what I have now: =IFERROR(VLOOKUP(MONTH(D8),Months,2),"") It works perfectly when all of the months are in the same year, but since the new year it is unable to differentiate between 2014 & 2015. My gut tells me...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top