Assuming the data you want to match is in A1:A5, you want to return whatever
is in B1:B5, C1 contains the criteria you want to match in column A, then:

=INDEX(B1:B5,MIN(IF(EXACT(C1,A1:A5)=FALSE,"",EXACT (C1,A1:A5)*ROW(INDIRECT("1:"&ROWS(A1:A5))))))

which must be entered with Control+Shift+Enter (it is an array formula).

Does this help?



"ob1kenob" wrote:

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.