$$Excel-Macros$$ hi help please

2009-11-11 Thread ashish koul
how can i go for case sensitive Vlookup and as well as using case sensitive in if condition thanks -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at

Re: $$Excel-Macros$$ hi help please

2009-11-11 Thread Aindril De
Hi Ashish, You can simply use the exact match option of vlookup to do this. The following links from MS have the complete explaination: XL: How to Perform a Case-Sensitive Lookup http://support.microsoft.com/kb/214264 How to Use VLOOKUP or HLOOKUP to find an exact match