Use the VLOOKUP formula in Excel to find values in a table. For example, you can use =VLOOKUP(A2,A10:C20,2,TRUE), or =VLOOKUP("Fontana",B2:E7,2,FALSE) as an alternative. It is all based on the columns and what you want to achieve.