Results 1 to 11 of 11

Delivering Data Based on a table

Threaded View

  1. #1
    Registered User
    Join Date
    12-08-2010
    Location
    Pittsburgh, PA
    MS-Off Ver
    Excel 2007
    Posts
    8

    Delivering Data Based on a table

    I have a moderate level of Excel knowledge, but I'm really struggling to come up with a solution to how to create a formula for this. Hopefully someone will be kind enough to help.

    In column A I have a set of numbers 0-10 and in column B I have a set of numbers 0-10. I'm trying to find a way to get column C to associate with those numbers. So for example if column A1=5 and B1=4 I'd like C1 to read "$75". Or if column A1=5 and B1=0 I'd like C1 to read "$35". So it's not a basic IF statement. I'm really looking for about 27 possible outcomes and for excel to figure out the conditions of which of those 27 outcomes has been met and provide the corresponding response.

    Hopefully this isn't too confusing. Thanks for the help!
    Last edited by joekrebs; 12-13-2010 at 05:49 PM.

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