Jan 31 2022 04:10 PM
I have been racking my brain for days trying to figure out how to do this - I need to pull the pricing data from another sheet based on same criteria in 2 columns that have drop downs on the main sheet. Sorry, not sure if I'm asking the right questions. I'm needing this to be able to provide estimates. The "unit cost" data is on Sheet 2. The criteria must be met in column A (2x4x8) and column B (pressure treated)- Both of these columns are drop down menus - ( pressure treated, cedar, composite). Sheet 2 has the pricing data.
So I need the price to change depending on what is selected from the drop down menus. Is this even possible?
I used to be pretty good at excel.... 15 years ago! Had a career change but now trying to help my son out with his new business building decks. Thanks for your help!
SHEET 2 >
Jan 31 2022 09:28 PM
Solution@julieshea Perhaps the attached file will help you get back into Excel. I've demonstrated INDEX combined with MATCH, using named ranges in Sheet2 to make the formula easier to write, read and maintain.
Sheet1:
Sheet2: Each of the coloured areas is a Named Range (prices, sizes and materials).
Feb 03 2022 05:29 PM
Jan 31 2022 09:28 PM
Solution@julieshea Perhaps the attached file will help you get back into Excel. I've demonstrated INDEX combined with MATCH, using named ranges in Sheet2 to make the formula easier to write, read and maintain.
Sheet1:
Sheet2: Each of the coloured areas is a Named Range (prices, sizes and materials).