I want a formula (In K17 of **attached SPREADSHEET**), to **return adjacent column**, from **opposite column NEAREST/CLOSEST value**, to **entered string**.

This attached spreadsheet has working VLOOKUP formula that was suggested elsewhere, however I wanted a formula different to VLOOKUP, something I can edit more easily, hence any other suggestions welcome:

Q1). **If I wanted a formula alternative OTHER then VLOOKUP, (Such as IF, COUNTIF or TRANSPOSE). **

Q2). **The VLOOKUP formula returns ONE ROW before, when it should be the NEXT ROW. **

For example, if **K8** = 10 MPG,

then the COST per MILE (**K17**) *should *equal = £0.613 (Row 7), __however__ the value returned by the VLOOKUP formula is the previous row (£0.638 Row 6), this is for the row for 9.8 MPG the nearest to 10 MPG *before *going over 10 MPG.

I guess to edit the VLOOKUP will be simple enough, but I'm not familiar with the VLOOKUP formulas.

Cheers Stephan

CROSSTHREAD HYPERLINKS:

http://www.excelforum.com/excel-gene...html?p=2685086

http://www.mrexcel.com/forum/showthread.php?t=606409