Results 1 to 6 of 6

Thousands of possibilities

Threaded View

  1. #1
    Registered User
    Join Date
    03-05-2006
    Posts
    31

    Thousands of possibilities

    What is the best way to do this? I have 6 cells that need to be populated based on the results of 4 different cells.

    C8 is the beacon score
    C9 is the year model (could be one of 25 possibilities)
    C10 is the model code (could be one of 115 possibilities)
    O5 is the lender (could be one of 9 possibilities)

    Based on the results of these 3 cells, the values of cells O6, O7, O8, O9, O10 and O11 will be determined. And all four of the 1st 4 cells I mentioned above will be required to determine each of the O6:O11 cells.

    For just one cell a simple IF formula would work but there are so many possible values that could result that I don't know how to approach this project. Macros? Formulas? I'm still a novice at excel so this is tough on me. Ideas?
    Last edited by sharkfoot; 03-26-2006 at 04:40 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