Is there a formula to enter data if entry was already in the sheet
Hi,
If I have a sheet with more than 2000+ entry (some needs to be re-entered) in it with name, phone number, email, address...etc (basic information), is there a way if a person is enter multiple times, it will auto-populate phone number, email, address?
Thank you.
Answers
-
@Christina Lam , have you considered using a VLOOKUP formula on the person's name within the phone number, email and address columns? You'd have to select a range through the current # of rows to drive any rows added in the future.
=IFERROR(VLOOKUP(Title@row, $Title$1:$[Estimate Hours]$474, 7, false), "")
I hope this works well for you.
-Jen
If you appreciate my response, please recognize the effort with an "Insightful" or "Vote Up" selection. Thanks!
-
Thanks @Jen Lange, but There is always sorting and filtering, so I need it to be a column formula where the person can also add email, or phone name if it's not already in there.
-
Okay., @Christina Lam. Makes sense. Let me dig further and see if I can come up with another approach or tweak my initial vision.
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 437 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!