Hi all,
I am new to Excel. I am trying to create a spreadsheet for voltage drop. My question is how to make data from a drop down menu equal a number. Example: I have a drop down of all the different wire sizes. When someone picks a certain wire size, I want the data to be a certain number (hidden if possible). So all the user has to do is pick the correct drop down selection and it automatically references a number that I have in another cell. Is this possible?
Thank you,
Bookmarks