Results 1 to 5 of 5

How to select from a table of values based upon column and row headers

Threaded View

  1. #1
    Registered User
    Join Date
    06-27-2012
    Location
    Leeds, UK
    MS-Off Ver
    Excel 2003
    Posts
    14

    How to select from a table of values based upon column and row headers

    Hi all,

    Im sorry to ask this, as im sure it is answered elsewhere, I cannot think of the best means to word a search to return what im looking for!

    Im trying to write an if statement to select from a table (as shown below) based upon the row and column property.

    So on the example workbook ive added, I want to return the number within the table to be selected from its two properties, The purchase price and the annual mileage. For example, for a purchase price of 13000 and an annual mileage of 17000 I need it to return 0.209 etc.

    I know I could do this with if statements but it seems terribly complex and drawn out and am sure that excel will have a much better solution for this!

    Many Thanks in advance! Peter
    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