Oct 25 2021 10:35 AM
I am trying to make a simple tool to calculate something given a list of data. We have a set amount of sheet metal with certain gauges. I want to be able to click the gauge from a dropdown (already done) and have it automatically fill in the corresponding thickness and radius cells from the same table that the gauge was pulled from (on sheet labeled "Sheet Metal").
Oct 25 2021 12:44 PM
Solution
If I understand what you're asking, it's a standard use of the VLOOKUP function, as I've done in the attached revision of your sheet. By the way, so far as I could tell, the drop-down had NOT been done, so I've added that as well.
Here's the VLOOKUP formula needed to get the thickness.
=VLOOKUP(C1,'Sheet Metal'!A2:C13,2,0)
And here's a website that explains VLOOKUP. If this is not what you meant by your question, please come back with a clarification. https://exceljet.net/excel-functions/excel-vlookup-function
Oct 25 2021 01:07 PM
Oct 25 2021 01:17 PM
Oct 25 2021 01:35 PM
Oct 25 2021 03:07 PM
Oct 25 2021 12:44 PM
Solution
If I understand what you're asking, it's a standard use of the VLOOKUP function, as I've done in the attached revision of your sheet. By the way, so far as I could tell, the drop-down had NOT been done, so I've added that as well.
Here's the VLOOKUP formula needed to get the thickness.
=VLOOKUP(C1,'Sheet Metal'!A2:C13,2,0)
And here's a website that explains VLOOKUP. If this is not what you meant by your question, please come back with a clarification. https://exceljet.net/excel-functions/excel-vlookup-function