data table lookup

  1. kelly mort

    VBA code to fill a table with data from another table in a unique way

    From the image below, I want to use the data from A4:A13 to fill A17:A46. I need a VBA approach can someone please help me out? Thanks in advance.
  2. S

    Pulling list of Unique Names from Refresh-able Table between Date Range (Or Month Number)

    Hello! Thanks for any help in advance: I'm attempting to create a "dynamic invoice" of sorts, with names being pulled from a "refresh-able" table. By that term, I mean an excel table that (I'm assuming) is pulling from an SQL query and just needs the "refresh all" button on the Data tab to be...
    • SirGruffles
    • Thread
    • data table data table lookup dynamic index & match index match refresh all unique list
    • Replies: 3
    • Forum: Excel Questions
  3. R

    Counting Data Based on Multiple Criteria

    Hi, I was wondering if i could get some help on a formula that i am looking to get up and running, I have tried Countifs and Index but seem to be having no luck in getting a result back, MY dilemma is based on two sheets, The first being just raw CSV data (this is what i want the formula to...
    • Redlad91
    • Thread
    • 26/06/2019 data data table lookup formula multiple countifs
    • Replies: 3
    • Forum: Excel Questions
  4. A

    Lowest value greater than or equal to in an array

    Hi all, Hoping you can help. I have a 2 variable data table that has 10 rows of data and 8 columns. I have a value that I want to look up in the array and return the lowest value that is greater than or equal to the number that I want to look up. I found a way to do this within a column, but...
    • Adam1988
    • Thread
    • array lookup complex lookup data table lookup greater/less than
    • Replies: 5
    • 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