Hello, I hope someone can help me please.
I think I'm looking for a vlookup formula.
I have a workbook and sheet 1 has my form. In cell B7 has a drop down with different sizes labeled as Finish OD (in.) and in cell E7 I have a drop down with different sizes labeled as Start OD (in.) size and in cell B8 has a drop down with different Wall thickness (in.) sizes. What I would like is for a user to choose a Finish OD and Start OD and Wall Thickness from the drop downs then do a vlook up and populate the Stretch size in cell B11.
On sheet 2, I have a form with all the different OD sizes and Wall sizes. Cell A9:A65 contains Start OD (in.), cell B9:B65 contains Wall Thickness, cell C9:C65 contains Finish OD (in.), cells D9:D65 contains Wall Thickness (in.) and cells E9:E65 contains the Strtech Size.
Also, not all the sizes 9 through 65 are in my drop downs yet, does that matter or as long as the user chooses any combination that is listed on form the vlook up will pick the appropriate stretch size?
Thank you for your help!!
Ronak
Bookmarks