2-dimensional

  1. L

    VBA Does declaring Array range with Cell make it a 2-Dimensional array?

    Might be a dumb question, but I have used the following to create an array in VBA - Dim CurrMonth As String Dim PosMatch As Variant Dim MonthDayCount As Variant Dim MonthDays As Variant CurrMonth = Format$(Date, "MMMM") With Worksheets("Tracker")...
  2. D

    2-D / Matrix usage of COUNTIFS or SUMPRODUCT(ISNUMBER(SEARCH()))

    Hello, 1st time poster here. I am trying to create a countif or a sumproduct which: 1) recognizes which column it needs to count from, and then counts based upon if the entry in that column meets another criteria. So in this example, cell B3 would look at all of Row 1, find 'Tom' in Column E...
  3. B

    2-Dimensional Vlookup

    Hey! I was able to figure out how to do a two-dimensional vlookup with the match function. But I also need to do a 2 dimension vlookup in the reverse order. (ex. bring the info from a list into a chart.) I've included a very simple example below to help. Below is the information I am given...
  4. B

    2-Dimensional Vlookup

    Hey! I was able to figure out how to do a two-dimensional vlookup with the match function. But I also need to do a 2 dimension vlookup in the reverse order. (ex. bring the info from a list into a chart.) I've included a very simple example below to help. Below is the information I am given...

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