Microsoft Office Tutorials and References
In Depth Information
5. In cell B3 , type SI3049209 .
The value in cell B3 is smaller than the smallest value in the Shipments table’s first
column, so the VLOOKUP formula displays the #N/A error code in cell C3.
6. In cell B3 , type SI3049245 .
The ShipmentID typed into cell B3 is greater than the last value in the table’s first
column, so the VLOOKUP formula displays the last value in the target column (in
this case, the fourth column). Therefore, the value 44493 appears in cell C3.
CLEAN UP Save the ShipmentLog workbook, and then close it. If you are not
continuing directly to the next chapter, exit Excel.