Between Formula in Excel for Numbers and vllokup the results.

[llozer]

Hi people!

I'm a regular reader of the newsletter, and one great appreciated this blog!

Now, I need a help with a question. (I think that's easy for you!)


I have a spreadsheet with the following data:

- car #01 to #05

- A range of values ​​that are differentiated per kilometer driven.


I need a formula that will show me the value (cell) depending on the car and kilometer run.


Example:

I choose (a drop-down box, for example) the car # 02, I insert the Km traveled, and the function shows me the cell value corresponding to this critical between the car #, and Km range.


I don't know if I can use vlookup on this, because it needs to be checked if the green cell number (insert manualy) in between the range (Start Km and End Km).


Link to spreadsheet:

https://spreadsheets.google.com/spreadsheet/ccc?key=0Alhr2ZOfkSKGdEpXVGhkc1NpeUxYcTBUYWRQMnQzX0E&hl=en_US


Regards,

Leandro Machado

 

[Luke M]

=INDEX(C2:G63,MATCH(K12,A2:A63),MATCH(J12,B1:G1,0))

 

[llozer]

Hi Luke!! Thank you very much!!

It's work now!!


Just a correction:

=INDEX(C2:G63,MATCH(K12,A2:A63),MATCH(J12,C1:G1,0))