I want to create a drop down menu with products. When a product(sheet type)
is selected from the menu it will populate information about the product (lay
width & lb/lf) in two different cells. i.e when sheet type "sz-21" is
selected it will auto populate the lay width in one cell and the lb/lf in
another.

sheet type lay width lb/lf
sz-21 50 27.5
ez-88 55 29.28
jz-112 60 38.35

I can do the drop down menu with no problems. I am just having problems
with the IF(VLOOKUP) formula.
Thanks in advance...

What are you trying to do with IF(VLOOKUP(...))?

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Juhnny" wrote:

I want to create a drop down menu with products. When a product(sheet type)
is selected from the menu it will populate information about the product (lay
width & lb/lf) in two different cells. i.e when sheet type "sz-21" is
selected it will auto populate the lay width in one cell and the lb/lf in
another.

sheet type lay width lb/lf
sz-21 50 27.5
ez-88 55 29.28
jz-112 60 38.35

I can do the drop down menu with no problems. I am just having problems
with the IF(VLOOKUP) formula.
Thanks in advance...

Hi

Assuming your table is in cells A1:C4 and supposing the cell where the
selection from the dropdown is cell H1,
Try
=VLOOKUP(H1,$A$2:$C$$,2,0) to return the lay width

=VLOOKUP(H1,$A$2:$C$$,3,0) to return the lb/lf value
--
Regards

Roger Govier


"Juhnny" wrote in message
...
I want to create a drop down menu with products. When a product(sheet
type)
is selected from the menu it will populate information about the
product (lay
width & lb/lf) in two different cells. i.e when sheet type "sz-21"
is
selected it will auto populate the lay width in one cell and the lb/lf
in
another.

sheet type lay width lb/lf
sz-21 50 27.5
ez-88 55 29.28
jz-112 60 38.35

I can do the drop down menu with no problems. I am just having
problems
with the IF(VLOOKUP) formula.
Thanks in advance...