match/index

  1. S

    reverse match/index

    Hello, I got a quick question about match/index and its reverse function. I'm fully familiar wth ow index and match function work, But when it comes to the other way around, Im confused. for instnce, if i have a data set as written below in column K-L, and I have a blank cell set like...
  2. S

    Copying Data From One Sheet to Another Based on Column Headers

    Hi Everyone, This will be my first post. I've researched this problem for hours and I can't find a solution. I have two worksheets in the same workbook. Worksheet_A - has 20 columns and Worksheet_B - has about 50 columns. I need a macro, or preferably a index/match formula, to copy the data...
  3. H

    Need Help with a Formula for solar pump system sizing sheet

    Hello, I’m trying to configure a solar pump system sizing sheet. Basically, after calculating several criteria, a solar pump model should be automatically selected. The criteria for selection are: required power and required head (m). I need to extract the right model from a table that compiles...
    • HEM79
    • Thread
    • formula & macro function access parameter if/and match/index vlookup
    • Replies: 5
    • Forum: Excel Questions
  4. H

    Skip a previously used cell

    Hi Guys, I am trying to use vlookup (or match/index) to return a value in an array but if the number is repeated, the formula I am using always returns the first match it finds. I've put a simplified version of what I mean below: 1 Cat 1 Dog 2 Fish In the first cell I am using...

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