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...
  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...

Some videos you may like

This Week's Hot Topics