lookup help

J

Jane Griffel

In D18 is a pull down list from L6:L34 I want items from N6:N34 to generate
in D19 when I choose an item in D18 from the pulldown list that is generated
form the items in L6:L34 what is that formula?
 
J

Jane Griffel

That worked thanks but what represents the end of the formula 3,0) just so I
know for future reference
 
D

David Biddulph

VLOOKUP is a standard Excel function. As for every other Excel function
(except one), Excel help will tell you the syntax, and also usually give
examples, and probably a "See Also" link to related functions.
 
P

Pete_UK

The second parameter defines the table L6:N34, which is 3 columns wide
- hence, the 3 means to bring the data from the 3rd column (i.e.
column N) of this table corresponding to a match between D18 and
column L. The final parameter means to look for an exact match - it
could also be set to FALSE.

Hope this helps.

Pete
 
Top