VLOOKUP: Vertical Lookup in Excel

Excel will select the lower value in the range (so for a value of $10,000, it will match to the $5,000 row). This approach can be used for names, addresses and Excel will do its best to find the closest matching record, just like it did in the range example above. ................
................