Oct 06 2022 04:27 PM - edited Oct 06 2022 04:44 PM
Howdy Team!
I am trying to add VLOOKUP to a spreadsheet. I have place the created a formula to assign a number to drop down list items. For example, upon selecting 750mL from a drop down list, I have added a VLOOKUP formula that assigns a value of 25.36oz to 750mL. I set up the information needed to assign value on the drop down menu in a data validation chart.
My challenge is that I am unable to copy this formula onto the hundred or so items listed on the spreadsheet. How can I copy this formula without it changing the formula cells that are assigned to the data validation chart? Right now I am having to change each formula manually.
Thank You for your Assistance,
Oct 06 2022 04:48 PM
SolutionOct 06 2022 04:55 PM
Oct 06 2022 04:48 PM
Solution