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.

Find more posts tagged with

Formulas

Accepted answers

All comments

Jen Lange

@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!

Christina09

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.

Jen Lange

Okay., @Christina Lam. Makes sense. Let me dig further and see if I can come up with another approach or tweak my initial vision.

Christina09

Thank you @Jen Lange

Hope something will work.

Have a great weekend!!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.