match 2 columns

adityatandel

Board Regular
Joined
Aug 10, 2007
Messages
69
Col 1 Col 2 Match
111111 00000111111 Y
222222 00000222222 Y
233444 00000356455 N

what is the formula to get the Y and N in the match field?
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

shemayisroel

Well-known Member
Joined
Sep 11, 2008
Messages
1,867
Could you confirm if any of the numbers are in TEXT format?

Also, would there always be 5 leading 0's?
 

shemayisroel

Well-known Member
Joined
Sep 11, 2008
Messages
1,867
Actually try this in C1 to assess values in A1 & A2

C1 and copy down

=IF(VALUE(B1)=A1,"Y","N")

This will work even if the values in Column B are are in TEXT
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,597
Messages
5,512,313
Members
408,886
Latest member
kashifziatevta423

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top