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?

Try this in D19:

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

Hope this helps.

Pete

On Dec 3, 12:29*am, Jane Griffel
wrote:
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?

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

"Pete_UK" wrote:

Try this in D19:

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

Hope this helps.

Pete

On Dec 3, 12:29 am, Jane Griffel
wrote:
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?

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.
--
David Biddulph

"Jane Griffel" wrote in message
...
That worked thanks but what represents the end of the formula 3,0) just so
I
know for future reference

"Pete_UK" wrote:

Try this in D19:

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

Hope this helps.

Pete

On Dec 3, 12:29 am, Jane Griffel
wrote:
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?

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

On Dec 3, 12:55*am, Jane Griffel
wrote:
That worked thanks but what represents the end of the formula 3,0) just so I
know for future reference



"Pete_UK" wrote:
Try this in D19:

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

Hope this helps.

Pete

On Dec 3, 12:29 am, Jane Griffel
wrote:
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?- Hide quoted text -

- Show quoted text -