Comparing 2 Columns?

  • I can't seem to get any of the usual functions I use (Vlookup, Match, Error) to work for what I need, I am wanting to See if The value in column A in the table is included in Column L. The Reason I need this is because I only need to show the Row if Cell A of the row is in column L.

    Column K is the column in which i was using to notate weather the value was in column L

  • It looks like the numbers in column A are true numbers, while the numbers in column L are text entries.

    You will need to either convert column A to text (Data>Text to Columns > Next > Next > Select Text > Finish)

    or change formula to convert number to text...

    e.g =MATCH(A2&"",L:L,0)

    Where there is a will there are many ways. Finding one that works for you is the challenge!

Participate now!

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