Comments on: VLOOKUP to compare two columns in Excel for common values and missing data

When you have data in two different lists, you may often need to compare them to see what information is missing in one of the lists or what data is present in both. Comparison can be done in many different ways, which method to use depends on exactly what you want from it. Continue reading →

Table of contents

Comments page 2. Total comments: 56

  1. Trying to look for unique values in 2 columns. I have used trim, conditional formatting (unique values) and I am still getting highlighted text even though I can see the same number in the next column!

  2. Nice!! this worked for me for-

    Excellent work guys, keep the good things coming and you would get good blessings in return from individuals like me.

    =IFNA(VLOOKUP(A3, $D$3:$E$10, 2, FALSE), "") :) :)

    Thanks,
    Vinay S.

  3. I like to do something like this, I have a table of about 20k items and they are being compared to a new list of items, what i like to do is

    if A1 = I1

    then copy comment in K1 into G1

    the biggest things is that i have some items that are like 8 or 9 all of the same items. I want to ensure they match or skip to the next as it goes through them all.

    How is this done without a macro

  4. Hi
    VLOOKUP function I want both whatever in column B & column C and at the same time if any column is empty in column B & column C, need only one cell value. Hope you get my point, waiting for the solution
    A B C
    ID Class 1 Class 2
    1 Q P
    2 L
    3 R
    4 T
    5 Y

      1. Hi
        In column A there are IDs of some students and in column B & column C these are name of the subjects, vlookup function if I want any ID of a student I need subjects of both if they are in both column B & C. At the same time if any subject is missing in any column these B & C then I need only one subject in vlookup function, hope you get the task. Thanks in advance

        Regards
        Sazedul Munna

        1. Hi!
          The information you provided is not enough to understand your case and give you any formula. However, keep in mind that the VLOOKUP function can only return values from one column. To get multiple values using VLOOKUP, use this instruction. You can use two VLOOKUP formulas to get values from two columns.
          To get data from multiple columns using a formula, you can use the FILTER function.

          1. Hi
            Please advise how can I share my file with you so that I can get my expected result, thanks

            Regards
            Sazedul Munna

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)