VLOOKUP - random responses

04/30/21
Accepted

Having trouble with random responses from VLOOKUP. What is puzzling is that all options have been copied or transferred the same way but give a different result, any help appreciated!


Best Answer

  • Mark CronkMark Cronk ✭✭✭✭✭
    Accepted Answer

    Good evening,

    Add ", False" to the end of you VLOOKUP formula.

    =VLOOKUP([email protected], {CQ Dec........}, 2, False)

    Fix the problem?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Answers

  • Mark CronkMark Cronk ✭✭✭✭✭
    Accepted Answer

    Good evening,

    Add ", False" to the end of you VLOOKUP formula.

    =VLOOKUP([email protected], {CQ Dec........}, 2, False)

    Fix the problem?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  • Thank you Mark!

  • Mark CronkMark Cronk ✭✭✭✭✭

    Glad you found a solution. Thank you for contributing to the Community.

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Sign In or Register to comment.