Vlookup Contact List... Recognition after Save

07/02/21
Answered - Pending Review

I'm using a helper column with Vlookup to populate a email address from a contact list sheet based on the name of the person in an adjacent column. The contact is populated properly when the sheet first opens but then it's like it is not recognized after a couple seconds of being open and thus is not brought into a filter based on the "Current User". What's even weirder is after the Save button is pressed, the contact is populated properly. See below formula and attachments.


Also attempting to assign them to a hierarchy but I don't think that is the issue.


=IF(ISBLANK([GTN Responsibility]@row), VLOOKUP(PARENT([GTN Responsibility]@row), {VLookUp Sheet Range 1}, 2, false), VLOOKUP(([GTN Responsibility]@row), {VLookUp Sheet Range 1}, 2, false))

GTN Responsibility = Person's Name

VLookUp Sheet Range = Contact List


Answers

  • Bassam KhalilBassam Khalil ✭✭✭✭✭
    edited 07/02/21

    Hi @ThomasWh

    Hope you are fine, try to use Index With Match instead of VLOOKUP

    PMP Certified

    [email protected]

    www.mobilproject.it

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • Thomas WhiteleyThomas Whiteley ✭✭✭✭

    Unfortunately, the same thing is happening. When the sheet is opened or refreshed, the contact list is recognized for 4 seconds and then becomes unrecognized. Only after I press the Save button does it become recognized again.


    New formula with Index/Match:

    =IF(ISBLANK([GTN Responsibility]@row), INDEX({VLookUp Sheet Range 3}, MATCH(PARENT([GTN Responsibility]@row), {VLookUp Sheet Range 4}, 0), 0), INDEX({VLookUp Sheet Range 3}, MATCH([GTN Responsibility]@row, {VLookUp Sheet Range 4}, 0), 0))

Sign In or Register to comment.