Results 1 to 8 of 8

Lookup a value in a table having entered 2 key values. INDEX ?

Threaded View

  1. #1
    Registered User
    Join Date
    04-14-2008
    Posts
    4

    Lookup a value in a table having entered 2 key values. INDEX ?

    Hi,

    I have a table of money rates. The monthly rate depends upon
    1. how long a loan is taken out and
    2. how much is borrowed.

    The user has to enter these 2 bits of info before excel examines a table selects a rate. A simple formula (which even I could do!?) calculates the monthly payment.

    Please see the attached. I nearly got there using INDEX, but the trouble is that the value column contains a range rather than a fixed value.

    I would be most grateful for a solution.

    Thanks in advance.

    Rob
    Attached Files Attached Files

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