M
M G Henry
I have a workbook with several sheets.
What I am needing to do is use V Lookup to return the value in the
second column referenced by the foms control combo box. The combo box
references values on a sheet called "Frac" with a cell range of
A1:B31
I am able to link the forms control combo box to return the index
value to the column under the combo box, which is cell G7 on a
worksheet called "Worksheet"
What I cannot seem to do is get the second value to populate Cell G9
on the "Worksheet" with the value from the B1:B31 range on the Frac
worksheet that corresponds to the Index value in G7
What I am needing to do is use V Lookup to return the value in the
second column referenced by the foms control combo box. The combo box
references values on a sheet called "Frac" with a cell range of
A1:B31
I am able to link the forms control combo box to return the index
value to the column under the combo box, which is cell G7 on a
worksheet called "Worksheet"
What I cannot seem to do is get the second value to populate Cell G9
on the "Worksheet" with the value from the B1:B31 range on the Frac
worksheet that corresponds to the Index value in G7