VLookup?????

[James Johnson]

I have a price sheet that has the length in row #2 and is displayed i
the following format 40-45. The diameter is column A and is displaye
as follows: 1.5 , 1.75, 2 etc. down to 4. The pricing is in the body o
the table. I want to be able to have the people enter Diameter an
Length and the price is displayed. Can the length be displayed in
drop down box so that the user can just pick the length "range" that h
needs. I do not know how to program in VB so that is not an option a
this time. Can any one help me with this

 

[Biff]

Hi James,

You can use dropdowns for both length and diameter. The
basic formula for returning the price would be:

=VLOOKUP(diameter,table_array,MATCH(length,length_index)+1)

It would be easier to send you an example worksheet than
try to explain how it works. If you're interested, post
back with a good email address. (munged, of course!)

Biff