Is there a formula to enter data if entry was already in the sheet

04/29/21
Answered - Pending Review

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.

Tags:

Answers

  • Jen LangeJen 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([email protected], $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!

  • Christina LamChristina Lam ✭✭✭✭✭

    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 LangeJen 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.

  • Christina LamChristina Lam ✭✭✭✭✭

    Thank you @Jen Lange

    Hope something will work.

    Have a great weekend!!

Sign In or Register to comment.