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, ...
- 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.
=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
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
