| Home |
| Search |
| Today's Posts |
|
|
|
#1
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) | |||
Hybrid Mode
