horizontal lookup

  1. S

    Date Range data retrieval

    Hello all, Wondering if anyone can help me with my query; I've a spreadsheet Sheet 1 contains <colgroup><col><col span="2"></colgroup><tbody> <colgroup><col><col><col></colgroup><tbody> Date From To 01/01/2018 07/01/2018 Name Time Name 1 07:00:00 Name 2 Name 3...
  2. A

    Array Issue, Vertical and Horizontal criteria

    Hi All, I have an issue that I am hoping someone can help me with. <tbody> 31/10/2017 Manual Entry Orange Manual Entry 31/07/2017 31/08/2017 30/09/2017 31/10/2017 30/11/2017 Apple 65,906.16 64,208.91 60,553.10 61,147.29 (65,168.44) Orange 82,423.36 79,439.45...
  3. M

    Searching a Table with a horizontal and vertical value

    Dear all, Currently im familiarizing myself more and more with excel. However I've run into a rather annoying problem. I have made a table which is rougly 60 vertical cells and 70 horizontal cells. Out of a prior calculation 2 keys are found. One horizontal value , one vertical value. Now I'd...
  4. B

    Populate Combo box with Index/Match using horizontal headers

    Hi, I'm having a bit of difficulty in populating a desired list through the use of a combo box, I'm hoping someone here has he smarts to help me. We have a training register to show the mandatory training required per position, I would like the user to select the position from the combo box &...

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