lookup help

[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?

 

[Pete_UK]

Try this in D19:

=VLOOKUP(D18,L6:N34,3,0)

Hope this helps.

Pete

 

[Jane Griffel]

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

 

[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