The range I1:J13 lists project details, including the ID code that VSS producers use to refer to
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Related Book For
International Marketing And Export Management
ISBN: 9781292016924
8th Edition
Authors: Gerald Albaum , Alexander Josiassen , Edwin Duerr
Posted Date: