Formula

Try these examples:

Sample Explanation
=VLOOKUP(A2,Sheet2!A:B,2,FALSE)
This formula looks up the value in cell A2 within the first column of Sheet2!A:B, and returns the corresponding value from the 2nd column. The FALSE parameter ensures an exact match.
Quick Tips
  • •Paste any Excel or Google Sheets formula
  • •Get explanations in multiple languages
  • •Try the example formulas to get started
  • •Use the AI builder to create new formulas
Popular Formulas

Click any formula to try it