In A6

=INDEX(A2:B2,MATCH(TRUE,EXACT(A5,A1:B1),0))

Please note that this is an array formula. Within the cell in edit mode (F2)
paste this formula and press Ctrl+Shift+Enter to apply this formula. If
successful in the Formula Bar you can notice the curly braces at both ends
"{=<formula}"

If this post helps click Yes
---------------
Jacob Skaria


"danpt" wrote:

How do I make Range("A6") to return 97, as given in the sub.

Sub CaseSensitiveLookup()
Range("A1") = "a"
Range("B1") = "A"
Range("A2") = "97"
Range("B2") = "65"
Range("A5") = "a"
Range("A6") = "=LOOKUP(A5,$A$1:$B$1,$A$2:$B$2)" 'needs correction
End Sub