How can I automatically populate a cell with the same info from another cell (SAME COLUMN /DIFF ROW)
Hello,
I have 1 sheet that I am creating and will continually add new rows of data to over time. There may be cases where an account number is listed more than once on multiple rows. If the account value was captured previously I want the account value number to autopopulate in the new row for that same account number. Ex: if I have an order from 3 months ago for the same account number I want the account value dollar amount to be entered as soon as I add the new order. What formula do I need to make the column? This is within the same sheet / different rows / same column.
Is this an index / match formula? Or something else? If you have an example of how to write the formula that would be great too because all I can find are examples from a 2nd sheet.
Answers
-
Is this a case where it would only be listed a second time, or would it be listed multiple times. In this instance I would add a couple of helper columns that have a SUMIFS formula. If you can provide a screenshot of the column names that you have, we could help you write a formula. If you want to go over it one on one - email me. michelle.choate@outlook.com
Michelle Choate
michelle.choate@outlook.com
Always happy to walk through any project you need help with!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!