Value: Explanation: 0: Find an exact match; return #N/A if none found. This is the argument’s default value.-1: Find an exact match; return the next smaller item if no match is found.

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 ...