Forum Discussion
VLOOKUP
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,
- It's difficult to interpret exactly what you require from your post, however, it does sound like you may benefit from the use of 'absolute references' in your formula. The addition of a dollar sign in front of a column and / or row reference, within the formula, will fix the reference point.
- It's difficult to interpret exactly what you require from your post, however, it does sound like you may benefit from the use of 'absolute references' in your formula. The addition of a dollar sign in front of a column and / or row reference, within the formula, will fix the reference point.
