| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Worked perfectly! Pretty clever - thanks again!
"Peo Sjoblom" wrote: =INDEX(D2:D50,MATCH(1,--EXACT(C2:C50,A1),0)) also array entered -- Regards, Peo Sjoblom "Dan in NY" wrote in message ... Getting closer, but the FIND pulls in an earlier lookup decode that simply contains the searched for item. For example, if one of my lookup values is "F", your solution returns the column B for "CFD" - I assume since it finds the "F" in "CFD" before it gets to the "F" entry (the lookup decode list is in alphabetical order). hmm...tricky. Any more suggestions? Thanks! "Peo Sjoblom" wrote: One way (albeit replacing vlookup with another formula) Assume the vlookup would look like this =VLOOKUP(A1,C2:D50,2,0) to lookup a case sensitive string from A1 in column C and return the values from D would be =INDEX(D2:D50,MATCH(1,--ISNUMBER(FIND(A1,C2:C50)),0)) entered with ctrl + shift & enter -- Regards, Peo Sjoblom "Dan in NY" wrote in message ... I'm using vlookup for translating a code into a decode value. The codes are in both lowercase and uppercase, unfortunately with the same values (e.g., cnv and CNV represent 2 different things). Anyone know how to make vlookup case sensitive? Or is there another fancy excel function that can provide the equivalent functionality? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Amount or Numbers in Words | New Users to Excel | |||
| Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
| Spellnumber | Excel Worksheet Functions | |||
| Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
Threaded Mode
