View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ob1kenob
 
Posts: n/a
Default Getting a case sensitive match?

I have been attempting with a simple listing enter the following data:

A1
a1 32
A1 53

Changing cell C1 from A1 to a1 I should get either 32 or 53.

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

returns "#VALUE!"