Help required to complete formula for 2 drop downlists
Hi all, please find attached link to spreadsheet that I'm working on. I have one cell that is fed by a table that I'm trying to match up numbers from but controlling the outcome of the cell by two different drop down lists. I have been struggling with this to make it work and don't know if it is possible, any help would be appreciated. The first drop down is in cell (D3) it controls the pitch, the other drop down list is in cell (A23) it controls the product, in cell (K23) is where the the number comes up that I'm trying to achieve, as you can see on the spreadsheet I have been able to make it give me the first answer correct from the table, but I'm unable to finish the formula. Here is the link to the spreadsheet, it's downloadable. Thank you https://docs.google.com/file/d/0B50j4eNSlSxjQVNqdzhIal95bEU/edit?usp=sharing
Hi all, please find attached link to spreadsheet that I'm working on. I have one cell that is fed by a table that I'm trying to match up numbers from but controlling the outcome of the cell by two different drop down lists. I have been struggling with this to make it work and don't know if it is possible, any help would be appreciated. The first drop down is in cell (D3) it controls the pitch, the other drop down list is in cell (A23) it controls the product, in cell (K23) is where the the number comes up that I'm trying to achieve, as you can see on the spreadsheet I have been able to make it give me the first answer correct from the table, but I'm unable to finish the formula. Here is the link to the spreadsheet, it's downloadable. Thank you https://docs.google.com/file/d/0B50j4eNSlSxjQVNqdzhIal95bEU/edit?usp=sharing
Last edited: