Using the Lookup Function to Obtain Values from a Table

When you use VLOOKUP, you must always "look up" in the first column of the table, and retrieve associated information from columns to the right in the same row; you cannot use VLOOKUP to look up to the left. If it is necessary to look to the left in a table (maybe it's not convenient or possible to rearrange the data table so as to put the columns in the proper order to use VLOOKUP), you can sometimes accomplish this by using the LOOKUP function.

LOOKUP{lookup_value,lookup_vector,result_vector) has two syntax forms: vector and array. The vector form of LOOKUP looks in a one-row or one-column range (known as a vector) for a value and returns a value from the same position in another one-row or one-column range. The values in lookup_vector must be sorted in ascending order. If LOOKUP can't find lookup_value, it returns the largest value in lookup_ vector that is less than or equal to lookup_value.

Ethylene Freezing

Ethylene Freezing

0 0

Post a comment