Homework answers / question archive / 1)Go to the Lookup Creat a formula that provides this information as follows: worksheet, which lists project details, including the ID code that staff in the Development Division use to refer to the projects

1)Go to the Lookup Creat a formula that provides this information as follows: worksheet, which lists project details, including the ID code that staff in the Development Division use to refer to the projects

Computer Science

Share With

1)Go to the Lookup Creat a formula that provides this information as follows: worksheet, which lists project details, including the ID code that staff in the Development Division use to refer to the projects. Dean wants to find a simple way to look up a project name based on its ID.

a.       In cell H3, begin to enter a formula using the VLOOKUP function.

b.       Use the Project ID (cell H2) as the lookup value.

c.       Use the Lookup table (range A2:E23) as the table_array.

d.       Use the Project Name column (column 2) as the col_index_num.

e.       Specify an exact match (FALSE) for the range_lookup.