D
danpt
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
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