In cell q3, nest the existing vlookup function in an iferror function. if the vlookup function returns an error result, the text "invalid staff id" should be displayed by the formula.

Normally VLOOKUP is an inbuilt function which is available in MS-excel sheet and used to search the data in vertical column of index.

Explanation:

IFERROR functions returns error means search data type is invalid. In this scenario invalid staff id means either staff id data type is mismatch.

These scenario happens when end user search string data in numeric column of staff id. End user has to correct the staff id data type from string to numeric. Some cases the staff id has invalid data such some special characters are used, such as “-“,”=” etc.

End user has to remove special characters in staff id column and check whether VLOOKUP gives error.

these  signals travel  down a part of the neuron called the axon, which is like a wire that carries the  signal  to othernerve  cells. on average a  nerve  cell sends a  signal  at about 50 meters per second, which is over 100  miles  an hour!