•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Stop table backfilling lookups
------SOLVED------
So I have
Col A - name
Col B - lookup to pull location based on name
We have a rotating staff rota when every 2 months people do a rotation in a remote only team.
This table started in dec and there was a staffing shuffle in Feb to a new remote team but when I change the xlookup to pull the new areas the table automatically applies the formula to the entire column resulting in the location area being incorrect for dec and Jan. Can I stop this from happening?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#AI formula generation techniques
#generative AI for data analysis
#Excel compatibility
#cloud-based spreadsheet applications
#formula generator
#Excel alternatives
#lookup
#backfilling
#XLOOKUP
#rotating staff rota
#remote team
#formula
#location area
#remote only team
#staffing shuffle
#table
#apply formula