You can use VLOOKUP with Google Sheets; it's similar to how the function works in Excel. The VLOOKUP formula can find values in tables on the same sheet or a different sheet, but it can only find ...

VLOOKUP is a commonly used search function that lets you look up a value in one table and use it in another. It takes its name from the fact that it performs a "vertical lookup" — it searches a ...