•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Pulling data from other tabs.
Is there a way to pull data from another tab, by simply writing a search word?
Example.. If I have a tab of values, x value 1, y value 2 etc..
Can I access those values in another tab with a formula based on "x" or "y" instead of the specific cell?
I'm making a spreadsheet of caloric content in different foods, to use when calculating the total caloric content of certain dishes, and it would be easier to just write "Sugar" and it automagically fills out the caloric content pr/100 g, instead of having to look it up every time.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#real-time data collaboration
#cloud-based spreadsheet applications
#big data management in spreadsheets
#generative AI for data analysis
#conversational data analysis
#rows.com
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#AI formula generation techniques
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#Excel compatibility
#collaborative spreadsheet tools