G
Gary D.
I have a chart that has in the one column (N) a list of sheet metal gage
numbers and in the previous column (M) the gage number represented in numeric
form. The user will select the desired gage size via a drop down menu that
references the values in column N.
I would like to have a cell display the numeric size of the gage number
selected.
The value I want to display is in the same row and 1 column to the left of
the cell selected with the drop down.
Is there a way to display this value automatically based on value selected
in drop down?
excel 2002, sp3
Thanks,
Gary
numbers and in the previous column (M) the gage number represented in numeric
form. The user will select the desired gage size via a drop down menu that
references the values in column N.
I would like to have a cell display the numeric size of the gage number
selected.
The value I want to display is in the same row and 1 column to the left of
the cell selected with the drop down.
Is there a way to display this value automatically based on value selected
in drop down?
excel 2002, sp3
Thanks,
Gary