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!

Register Yourself Login