Help with IF(VLOOKUP) formula

[Guest]

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

 

[Guest]

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

Dave

 

[Roger Govier]

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