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

    Files

    • Sean Tmp.xls

      (1.27 MB, downloaded 92 times, last: )
  • 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!