LOOKUP

Looks up value in one-row or one-column range.

Excel: Verified match
Google Sheets: Verified match
Returns: Any value

Examples

=LOOKUP(30, A1:A5, C1:C5)

	A	B	C
1	10		alpha
2	20		beta
3	30		gamma
4	40		delta
5	50		epsilon

Result gamma

Syntax

LOOKUP(lookup_value, lookup_vector, [result_vector])

lookup_value: any required
lookup_vector: range required
result_vector: range optional

Errors

#N/A: =LOOKUP(5,{10,20,30})

ADDRESSReturns a cell address as text from row and column numbers. AREASReturns the number of areas in a reference. HLOOKUPSearches first row and returns matching value. HYPERLINKThe text a link displays: clickability is the renderer's. INDEXReturns value at row and column in range. INDIRECTReturns reference specified by text string.