1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Description cell auto fill from Sheet 2?

Hello,

I need some help. I’m trying to build an inventory list of what’s going in and out. My previous job had this spreadsheet where it made inputting item names and descriptions quick. All I had to do was put the part item in a cell and the description for that part item would fill in by itself from all the info from a different sheet. I would like to know how that was done. Thank you!

Example:

On sheet 1. There’s an item tab and a description tab. Let’s say I input “PN50” under the item cell and the description would automatically fill the correct description “Pioneer - 50inch” that goes along with the item.

On sheet 2, i would have all the items and descriptions typed in and ready to go for sheet 1.

submitted by /u/BabyTyRe
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#Excel compatibility
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#financial modeling with spreadsheets
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#AI-powered spreadsheet
#Excel alternatives
#spreadsheet API integration
#inventory list
#spreadsheet