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.