+ Reply to Thread
Results 1 to 2 of 2

Making a calculation based on two input variables

  1. #1
    Registered User
    Join Date
    12-11-2007
    Posts
    15

    Making a calculation based on two input variables

    Hello. I have a sheet that I put together and I the sheet I have a table for which there are two rows and 5 columns. I created dropdowns to basically choose any row and any column and then return the corresponding value, however I cannot quite figure out the best way to do it. I know I can make an enormous nested if but that is not the best way. I am figuring it would use the INDEX and MATCH functions, but I cannot figure out exactly how to execute it. Can anyone point me in the right direction? Table is right in the middle. Thanks.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    12-11-2007
    Posts
    15

    Re: Making a calculation based on two input variables

    Alright nevermind, with a bit more tinkering, I figured it out using INDEX and MATCH. Thanks!

    Mods you can remove this thread if you like.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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