Looks through a sorted row or column for a key and returns the value of the cell in a result range located in the same position as the search row or column. Sample Usage LOOKUP(10003, A1:A100, B1:B10| support.google.com