VLOOKUP or something else

    I have a workbook where I am trying to lookup a value in column B of one sheet, find that value in another sheet in same workbook but give me the value from the third column of the second sheet. I have a formula but it comes up with #N/A. The formula is

    =VLOOKUP($B2,TELUS_SEPT_2022!$B$2:$C$1469,3,0)


    I have attached the workbook I am working with for your convenience.


    Thanks for any and all help.

    Hello,


    A quick test shows ONLY a single match for 5062384824 located in B14 and found in cell B73 in sheet : TELUS_SEPT_2022


    Could your database be partially truncated ???

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    1. Your strings in col B in the TELUS sheet are text while in the other sheet they are numbers so they cannot match

    2.=VLOOKUP($B2,TELUS_SEPT_2022!$B$2:$C$1469,3,0) is impossible as you are looking in the 3rd column of a two column range ( the lookup column refers to the range in your formula, not the position in the sheet

    Try

    Code
    =VLOOKUP($B2&"",TELUS_SEPT_2022!$B$2:$C$1469,2,0)

    instead and pull down

    As text is left aligned in cells and number are right aligned, NEVER apply manual alignment of columns before your formulas are working

    Pecoflyer Well Spotted ... !!!


    You are right ... !!! Text can disturb the whole process, especially if it not consistently applied to both the Source and the Destination.


    Bernie, attached is your Test File

    Would be Great if we, all, could benefit from the OP's feedback ... !!!

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Quote from Pecoflyer

    After 7000 + posts you still wonder ? :)

    I've thousands of posts on another forum, and it still frustrates me every day


    Could not agree MORE with you ... !!!


    Asking a question ... and NOT being interested in the Answer ... :D ;( 8o

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login