| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Case Sensitive Lookup
Thank you, Jacob
"Jacob Skaria" wrote: Using LOOKUP =LOOKUP(TRUE,EXACT(A5,A1:B1),A2:B2) 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Case Sensitive v-lookup needed | Excel Discussion (Misc queries) | |||
| countif function: how to distinguish case/make case sensitive | Excel Worksheet Functions | |||
| make sumproduct lookup case sensitive | Excel Worksheet Functions | |||
| Case Sensitive Compare, Lookup, etc???? | Excel Discussion (Misc queries) | |||
| Case Sensitive w/ IF | Excel Worksheet Functions | |||
Threaded Mode
