+ Reply to Thread
Results 1 to 2 of 2

inserting a formula to reference from a matrix (From:To)= X

  1. #1
    Registered User
    Join Date
    02-06-2020
    Location
    Greensboro, NC
    MS-Off Ver
    2016
    Posts
    1

    Angry inserting a formula to reference from a matrix (From:To)= X

    I am creating a matrix with a drop down. This is a tool for my peers to use to select one value for cell a and a second value in cell b and cell c would give them the correct instructions to follow.

    If Cell A=x and Cell B=y then Cell C=z or If Cell A=Y and Cell B=u then Cell C=z

    Cell A Drop Down options are 8
    Cell B Drop Down Options are 8
    Possible outcomes 10

    Do I have to put every argument in Cell C? This would be 3 pages long! UGH
    Is there an easy way to do this?
    I have been working on this for days but I am lost I have validation by list sheet for Cells A and B and I have the reference chart for Cell C.
    My end goal is that when the solution is found for Cell c that it is a hyperlink to a different sheet. but this is just too much right now. I and I am probably over thinking this! Thank you in advance!

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,728

    Re: inserting a formula to reference from a matrix (From:To)= X

    It would help if you attached a sample Excel workbook - instructions on how to do this are given in the yellow banner at the top of the page.

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] inserting a formula with a dynamic cell reference
    By mashley in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-17-2015, 02:56 PM
  2. inserting row causing formula reference issue
    By rexer231 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-06-2014, 12:52 PM
  3. how to reference a matrix?
    By effebruno in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-07-2014, 04:09 PM
  4. [SOLVED] Cell reference in formula changes after inserting a row
    By coreytroy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-12-2012, 12:18 AM
  5. Invalid or unqualified reference error when inserting a formula into a cell via VBA
    By AnthonyWB in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-11-2010, 10:06 AM
  6. Changing cell reference in a formula when inserting a row
    By Apel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-11-2009, 01:46 AM
  7. matrix reference or what
    By xx_yy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-07-2008, 07:34 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1