Forum Discussion
How do I auto-populate information from one tab to another in sheets?
An example is attached. Here's a screen grab that shows the formula, but you can see the actual in the attached file.
- rech_ypJan 21, 2022Copper Contributor
Hi,
I would like to know if we can populate the data if just type the part number and the rest of the data will be populated. What formula should I apply?
The rest of the info will be available from another excel or maybe different tab.
- mathetesSep 26, 2021Silver ContributorI'm leaving on a two week trip tomorrow and getting ready today.
Your problem sounds like it deserves an altogether new thread, in part because the brief description makes it appear that a macro might be involved in the solution (as well as it appear that this is already being a macro enabled file), I don'r work with macros---there are others here on this site who do. Also, when you start a new thread, please post a copy of your workbook so those who try to help can work with the real thing. - mathetesJan 21, 2022Silver Contributor
Use VLOOKUP, as shown in the attached file (and the image below).
Here, too, is a helpful on-line resource that can explain in greater depth how to use VLOOKUP as well as some of the other variants that Excel offers to retrieve information from a separate table of data.
https://exceljet.net/search?query=lookup
By the way, in the future it would make sense to start your inquiry here as a totally new thread. What you're asking isn't really the same as the prior exchanges on this one, and your inquiry could easily get buried.