Macro to Index/Match Two Criteria w Two Criteria

  • Hello,

    I’m new to VBA and need a macro that does the following:

    Take the named range for a column (“namedrange1” on worksheet “destination”) and a named range for a row (“namedrange2” on worksheet “destination”) - essentially a table matrix, look at each cell for each corresponding named range combination to see if it meets a specific criteria (value is greater than zero or has a value of “name”) on that worksheet (“Destination”).

    For each value that meets that criteria, find a value on another worksheet (“namedrangevalue” on worksheet “source”) where “namedrange1” = “namedrange3” (a column on worksheet “source”) and “namedrange2” = “namedrange4” (another column on worksheet “source”). All five named ranges are integers.

    This needs to be a macro and not a formula since each of those cells in the table matrix will be overwritten with user inputs. I’m sure this is easy VBA, but I’ve struggled to get anything working.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!