Excel 2000 : A Sample Application    Using Formulas  

The first column of the lookup table is G2:G4 (this notation means, "the range from G2 to G4") so we enter that in the Lookup_vector entry box.

(If you are following along, you may like to try clicking on the small icon right in front of the arrow. This allows you to select a range by dragging the mouse.)

 
screenbooks home site

10 of 27
  Text Author: Joe Orr   Copyright 2000 All Rights Reserved  
  Created with ScreenBook Maker   Last update: 12/20/2002   Additional Trademark and Copyright Information