Forum Discussion

Ray167's avatar
Ray167
Copper Contributor
Jan 02, 2019
Solved

Looking for a way to use a drop down menu to change cell references in a formula

Hi,    I have been scratching my head for a few days and have been googling for a few hours to try to figure out a solution, but to no avail. My situation is that I have a curtain store that makes ...
excel
Formulas and Functions
Macros and VBA
  • Yury Tokarev's avatar
    Yury Tokarev
    Jan 02, 2019

    Hello,

     

    Please see attached my solution. I have added 'Group' and 'Group & Inch' columns in each of the price tables, as well as a 'Price Group' column in the 'Estimate Sheet' table. I have also modified the following formulas of the Estimate Sheet:

     

    'Formula height' - included a reference to the 'Price Group'

    'MSRP$' - extended the lookup range to include all price tables. I have also removed '+1' after the 'Match' functions to make sure the price is pulled from the correct Width/height cell.

     

    Hope this helps

    Yury

     

Yury Tokarev's avatar
Yury Tokarev
Iron Contributor
Jan 02, 2019

Hello,

 

Please see attached my solution. I have added 'Group' and 'Group & Inch' columns in each of the price tables, as well as a 'Price Group' column in the 'Estimate Sheet' table. I have also modified the following formulas of the Estimate Sheet:

 

'Formula height' - included a reference to the 'Price Group'

'MSRP$' - extended the lookup range to include all price tables. I have also removed '+1' after the 'Match' functions to make sure the price is pulled from the correct Width/height cell.

 

Hope this helps

Yury

 

Resources