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
Bookmarks