The range I1:J13 lists project details, including the ID code that VSS producers use to refer to the projects. Bao wants to find a simple way to look up a project name based on its ID.

Create a formula that provides this information as follows:
In cell J3, begin to enter a formula using the VLOOKUP function.
Use the Project ID (cell J2) as the lookup value.
Use the Projects table (range A2:G23) as the table_array.
Use the Project Name column (column 2) as the col_index_num.
Specify an exact match (FALSE) for the range_lookup.