index function vba

  1. P

    VBA code :::::: Compile error: Expected : list separator or )

    I am trying to get the multiple results form a Range and cannot use vlookup so using INDEX Function. My formula "=INDEX(Sheet1!$A:$I,SMALL(IF(Sheet1!$A:$A=$A$2,ROW(Sheet1!$A:$A)),ROW(2:2)),7)" worked perfectly but not working in VBA code. I am getting "Compile error: Expected : list separator...
    • Prat14
    • Thread
    • index function vba row funtion vba vba - help vba .formula
    • Replies: 7
    • Forum: Excel Questions
  2. nardagus

    match and index macro question

    Hello guys and girls, I'd like to ask you a question about macro I made. I'm totally newbie in writing macros so forgive me taking your time with such a simple thing. :) Sorry for not using HTMLMaker but I get an error about "type mismatch" in excel version section (I'm using E2010). Any way...

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