Use the LOOKUP function

Use LOOKUP to look in a single row or column and find a value at the same position in a second row or column.

Syntax: LOOKUP(lookup_value, lookup_vector, [result_vector])

• lookup_value Required. Value to searches for in the first vector.

• lookup_vector Required. A one row or one column range.

• result_vector Optional. A one row or one column range. Range size must match lookup_vector.

Example: =LOOKUP(134,D1:D35,E1:E35) finds the value 134 in range D1-D35, and returns value from range E1-E35. 

Note: Values in lookup_vector must be in ascending order; 0, 1, 2, ..., A-Z, FALSE, TRUE. Uppercase and lowercase text are equivalent.

You can also use VLOOKUP or XLOOKUP.

Use LOOKUP to look in a single row or column and find a value at the same position in a second row or column.

Syntax: LOOKUP(lookup_value, lookup_vector, [result_vector])

• lookup_value Required. Value to searches for in the first vector.

• lookup_vector Required. A one row or one column range.

• result_vector Optional. A one row or one column range. Range size must match lookup_vector.

Example: =LOOKUP(134,D1:D35,E1:E35) finds the value 134 in range D1-D35, and returns value from range E1-E35. 

Note: Values in lookup_vector must be in ascending order; 0, 1, 2, ..., A-Z, FALSE, TRUE. Uppercase and lowercase text are equivalent.

You can also use VLOOKUP or XLOOKUP.

Use LOOKUP to look in a single row or column and find a value at the same position in a second row or column.

Syntax: LOOKUP(lookup_value, lookup_vector, [result_vector])

• lookup_value Required. Value to searches for in the first vector.

• lookup_vector Required. A one row or one column range.

• result_vector Optional. A one row or one column range. Range size must match lookup_vector.

Example: =LOOKUP(134,D1:D35,E1:E35) finds the value 134 in range D1-D35, and returns value from range E1-E35. 

Note: Values in lookup_vector must be in ascending order; 0, 1, 2, ..., A-Z, FALSE, TRUE. Uppercase and lowercase text are equivalent.

You can also use VLOOKUP or XLOOKUP.