Cell C13 formula: VLOOKUP( B13 , B3:G8 , 3 ) determines the cost to send a
13.7 pound package by courier
Cell D13 formula: VLOOKUP( B13 , B3:G8 , 5 ) determines the lowest cost to
send a 13.7 pound package
Cell E13 formula: VLOOKUP( B13 , B3:G8 , 6 ) determines the lowest cost mode
to send a 13.7 pound package
Note:
The leftmost column of the vertical table must be the key comparison column. It must be
sorted in ascending order.
It is often handy to specify the table by an absolute address
($B$3:$G$8) instead of a simple relative address (B3:G8). This
greatly simplifies copying vlookup formulas to other cells in your spreadsheet.