Forum Discussion

crfood's avatar
crfood
Copper Contributor
Oct 06, 2022

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.
  • Charla74's avatar
    Charla74
    Iron Contributor
    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.
    • crfood's avatar
      crfood
      Copper Contributor
      I figured it out with your direction. Thank You for your help!!
    • crfood's avatar
      crfood
      Copper Contributor
      =VLOOKUP(B7,formulas!A4:B6,2,FALSE)

      B7 will need to change but i need the rest of the formula to stay as is. Where would the $ need to be placed?

      Thank You

Resources