Excel LOOKUP Function – Google Sheets Alternative | ComTools

Learn Excel LOOKUP: what it does, Google Sheets support (Supported), alternatives (XLOOKUP), and convert formulas online.

What is Excel LOOKUP?

Legacy vector or array lookup.

Google Sheets compatibility

On Google Sheets, LOOKUP is marked as Supported.

Convert with ComTools

Paste a formula that uses LOOKUP into /excel-formula-converter, choose Google Sheets or Excel as the target, and get support status plus suggested rewrites.

FAQ

QDoes Google Sheets support LOOKUP?

Status: Supported. Common alternative: XLOOKUP.

QCan ComTools rewrite my formula automatically?

Simple renames (e.g. TEXTAFTER→REGEXEXTRACT, TEXTSPLIT→SPLIT) and simple LET expansions are attempted; complex formulas get guidance.