I am trying to create a summary table where when the user enters in a
criteria, the formula will look up the criteria, the year and name, and
return the value from another worksheet.

Criteria = A

Year1 Year 2 Year 3 etc
Name1
Name 2
Name 3
etc


Would I use the vlookup formula for something like this?