Function to difference two columns case sensitive and add the description from colum1

as I can see there is no matching IDs

your profile shows 5.2, is this Libre Office?

so update your profile to 365 ver. 2212 (I suppose)

could you post these "matched" IDs ? a few...

1. there were no case sensitive matches.

2. I made some. see shaded cells.

3. Next time upload a SAMPLE sheet (10-20 rows, not 22,001).

=IFERROR(INDEX(Page2!$B$2:$B$22001,MATCH(TRUE,EXACT(Page1!A2,Page2!$A$2:$A$22001),0)),"")

S, what do you mean??

Originally Posted by Glenn Kennedy

S, what do you mean??

I filtered ID (Page2) and 0031v0000203HSx doesn't exist but only 0031v0000203 (one only)

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.

Originally Posted by sandy666

I filtered ID (Page2) and 0031v0000203HSx doesn't exist but only 0031v0000203 (one only)

That whay I said "I made some" at point 2. I added some matches across the sheets, as there were NONE.

Originally Posted by Glenn Kennedy

That whay I said "I made some" at point 2. I added some matches across the sheets, as there were NONE.

ops, I overlooked this
there is NO case sensitive and case insensitive matches - post#2 (!@#$%^&**&^%$#@!!!!)