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

Christina09 · 04/29/21

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.

Jen Lange · 04/30/21

@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 · 04/30/21

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 · 04/30/21

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 · 04/30/21

Thank you @Jen Lange

Hope something will work.

Have a great weekend!!

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

Answers

Help Article Resources

Categories