Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup & Case Sensitivity
Hi All,
I am trying to compare two spreadsheets of text strings, I only want to find those that match content and case. Currently Excel says that they match even if the case is not matching ie Follow Up is not the same as Follow up But with my current standard vlookup statement, Excel returns these values as matching. Please can someone help. Thanks -- K Hogwood-Thompson |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup & Case Sensitivity
try this =IF(EXACT(K4,VLOOKUP(K4,I5:J11,1,FALSE)),VLOOKUP(K 4,I5:J11,2,FALSE)) change references accordingly. KHogwood-Thompson Wrote: Hi All, I am trying to compare two spreadsheets of text strings, I only want to find those that match content and case. Currently Excel says that they match even if the case is not matching ie Follow Up is not the same as Follow up But with my current standard vlookup statement, Excel returns these values as matching. Please can someone help. Thanks -- K Hogwood-Thompson -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=570257 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup & Case Sensitivity
One way ..
Assume you're using this in B1, with B1 copied down: =VLOOKUP(A1,$E$1:$F$10,2,0) Try placing this instead in B1, then array-enter the formula by pressing CTRL+SHIFT+ENTER, instead of just pressing ENTER: =IF(A1="","",INDEX($F$1:$F$10,MATCH(TRUE,ISNUMBER( FIND(A1,$E$1:$E$10)),0))) Copy B1 down Adapt the ranges to suit .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "KHogwood-Thompson" wrote: Hi All, I am trying to compare two spreadsheets of text strings, I only want to find those that match content and case. Currently Excel says that they match even if the case is not matching ie Follow Up is not the same as Follow up But with my current standard vlookup statement, Excel returns these values as matching. Please can someone help. Thanks -- K Hogwood-Thompson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup & Case Sensitivity
One more...
=INDEX(Sheet2!B1:B999,MATCH(TRUE,EXACT(A1,Sheet2!A 1:A999),0)) This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it correctly, excel will wrap curly brackets {} around your formula. (don't type them yourself.) Adjust the range to match--but you can't use the whole column. KHogwood-Thompson wrote: Hi All, I am trying to compare two spreadsheets of text strings, I only want to find those that match content and case. Currently Excel says that they match even if the case is not matching ie Follow Up is not the same as Follow up But with my current standard vlookup statement, Excel returns these values as matching. Please can someone help. Thanks -- K Hogwood-Thompson -- Dave Peterson |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup & Case Sensitivity
thanks, worked perfectly!
-- K Hogwood-Thompson "starguy" wrote: try this =IF(EXACT(K4,VLOOKUP(K4,I5:J11,1,FALSE)),VLOOKUP(K 4,I5:J11,2,FALSE)) change references accordingly. KHogwood-Thompson Wrote: Hi All, I am trying to compare two spreadsheets of text strings, I only want to find those that match content and case. Currently Excel says that they match even if the case is not matching ie Follow Up is not the same as Follow up But with my current standard vlookup statement, Excel returns these values as matching. Please can someone help. Thanks -- K Hogwood-Thompson -- starguy ------------------------------------------------------------------------ starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434 View this thread: http://www.excelforum.com/showthread...hreadid=570257 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Code | Excel Discussion (Misc queries) | |||
How to .. | Excel Discussion (Misc queries) | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
EXCEL:NUMBER TO GREEK WORDS | Excel Worksheet Functions | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) |