Excel nesting 3 if functions with vlookup

I need to use a min of 3 nested if functions along with vlookup function for sections

Co. Name

Address

City

State

Zip COde

The enter field of description.

This is the instruction I was given:

Lab Project adds error-trapping intelligence to the Order Form

The Vlookup function returns a #n/a! error if no lookup value is supplied, and various other errors whne invalid keys are entered. Use a combination of three levels of nested if functions, and other functions to avoid these problems.

You must use 3 of these: isblank, isnontext, isnumber, istext. You cannot use iferror function.