date array lookup

  1. G

    Date Look Up Formula

    I need help coming up with a formula which will pick up a date from a heading row if the rows below has a zero. For example I have a spreadsheet with dates as the main heading and below i have names of resources with forecasted hours. 1/1 1/2 1/3 1/4 1/5 1/6...
    • gahooja
    • Thread
    • conditional lo date array lookup if statement lookup row
    • Replies: 2
    • Forum: Excel Questions
  2. K

    Count Holidays, Country Wise Monthly

    Hi Frnds, i am working on the file where in need to Count holidays for Each country for the given Month in a particular year..!! i have tried with Countifs function but its not working Thanks & Regards Kumar
  3. V

    find date interval and lookup value

    i have compile a table that would determine the value im looking for, please see below: A || B || C || D || E || F 1 || Start Date ||End Date || Debit Month 2 || 19-Apr || 15-May || MonthA 3 || 17-May || 19-Jun...
    • voycron
    • Thread
    • array lookup date array lookup date intervals lookup value
    • Replies: 1
    • Forum: Excel Questions

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