two dimensional arrays

  1. J

    two dimensional formulas

    Hello! I'm trying to do a two-dimensional formula by combining the VLOOKUP and MATCH functions. What I'm trying to do is to have the formula fetch from the raw data (another tab); look up the UPC code and then see if that upc has sales under a specific store. UPC's are listed vertically and...
  2. D

    Copy-paste value loop within VBA array

    I wish to speed up my Monte Carlo simulation. I'm reading that dumping values generated by a loop into a VBA array, versus into Excel itself, followed by then dumping the completed array into Excel cells (if I need those values, which I do) is much faster. I've been reading about arrays all...
  3. B

    VBA Two Dimensional Array Search in Memory (MS Excel 2007)

    Hi Gurus, May I ask if is it possible to search in a two dimensional array in memory in MS Excel 2007? What I mean is that my array table values were searched cells which are scattered in the Excel sheet (just one worksheet). Or I need to print the array table then VLOOKUP on it? To elaborate...
    • byehp
    • Thread
    • arrays search two dimensional arrays vba vba 2007
    • Replies: 4
    • 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