I have a sheet to check first 6 digit column A against column D which has 8 digits.
the issue are the digits starting with 012345 with 01234567 give me no match or should read match but those starting with 1 to 9 first digit as first digit works .
Tried formating still the same
the formula used
Can anyone assist what is going wrong.
Please Login or Register to view this content.
Removed by JT
Maybe
=IFERROR(IF(LEFT(A2,6)=LEFT(D2,6),"CONFIRM","DOES NOT MATCH"),"DOES NOT MATCH")
Try this instead:
=IFERROR(IF(LEFT(D2,6)=A2,"CONFIRM","DOES NOT MATCH"),"DOES NOT MATCH")
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
you want confirm in all the yellow columns?
@ALIGW ,it worked those with 0 but with those starting with digit 1 shows does not match which is not true
@ROOT_ your formula worked .thank you
That's because A28-A31 are stored as numbers, not text., so it causes a mismatch. Use the evaluate formula feature to see this.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks