Forum Discussion
Amanda Rotger
Mar 10, 2019Copper Contributor
Formula Help - Square footage conversion
Hello all, I currently have a formula that is working in cell F4. This cell takes the Item description in cell A3, compares it to a data tab, and if those two match it gives me the square footage...
- Mar 10, 2019Insert $ before the row number, like this:
F$2
Twifoo
Mar 10, 2019Silver Contributor
Insert $ before the row number, like this:
F$2
F$2
- Amanda RotgerMar 10, 2019Copper Contributor
Thank you! I forgot about those silly $ signs. This has resolved my issue.
- TwifooMar 10, 2019Silver ContributorYou’re welcome.