I am attempting to do a vlookup and I have case sensitive items i.e. a1/A1.
My data goes from A1,A2,A3,A4,A5,A6, B1...c5, c6. I want the data from the
second column when done. I have tried:
=IF(EXACT(C1,INDEX(A1:B5,MATCH(C1,A1:A7,0),1))=TRU E,INDEX(A1:B5,MATCH(C1,A1:A7,0),2),"No exact match")
=IF(EXACT(C1,VLOOKUP(C1,A1:B5,1,FALSE))=TRUE,VLOOK UP(C1,A1:B5,2,FALSE),"No
exact match")
They both find the first instance and do not find the second. They will
return the data in the second column or give "No exact match" and not find
the second instance.