Page 101 - Excel for Scientists and Engineers: Numerical Methods

78 EXCEL: NUMERICAL METHODS

range-lookup is TRUE or omitted, VLOOKUP finds the largest value that is less
than or equal to lookup-value; the values in the first column of table-array must
be in ascending order. If range-lookup is FALSE, VLOOKUP returns an exact
match or, if one is not found, the #N/A! error value; in this case, the values in
fable-array can be in any order. You can use 0 and 1 to represent FALSE and
TRUE, respectively.

Using VLOOKUP to Obtain Values from a Table
The spreadsheet in Figure 5-1 (see folder 'Chapter 05 Interpolation',
workbook 'Interpolation 1', sheet 'Freezing Point') lists the freezing point, boiling
point and refractive index of aqueous solutions of ethylene glycol; the complete
table, on the CD-ROM, contains data for concentrations up to 95% and extends
to row 54.

Figure 5-1. Portion of a data table.
(folder 'Chapter 05 Interpolation', workbook 'Interpolation 1', sheet 'Freezing Point')