Hi Guys,
I'm hoping someone can provide a working solution to this scenario:
I have two worksheets, one with the formulas on and one with data in an array. On the worksheet with the formulas I have two dropdown lists in cells A1 and A2. Based on the choices selected in A1 and A2 I want to see the result returned from the array in the data worksheet and displayed in cell A3.
The example is that I have a range of glass thickness in the first list (A1) and a range of hole diameters in the second list (A2) and I want to see the cost presented in A3 based on the prices stored in the array
I know how to use a list and VLOOKUP but don't know how to work with the combination of two lists?
any help would be much appreciated.
cheers
yogi62
Bookmarks