Alex Makula is a project manager for the Content Shop, an online firm based in New Haven, Connecticut, that provides written content for websites. Alex is compiling data on the contract writers and editors the company works with, and he asks for your help completing the workbook and analyzing the data. Switch to the Contract Writers worksheet, where Alex created a formula with the VLOOKUP function to look up contractor names by their Contractor ID. Other project managers will use this workbook, and he wants to alert them when they enter an incorrect ID number. In cell B4, nest the existing VLOOKUP function in an IFERROR function. If the VLOOKUP function returns an error result, display "Invalid Contractor ID" as the error text.

(not sure what to really do if you could tell me it by step by step not just the formula)

Content Shop Contract Writers Content Shop Contract Writers