1. Vlookup is not case-sensitive 2. If Lookup value has duplicates in the lookup column, then it returns 1st found value 3. Vlookup cannot pull values which are on the left side from Lookup column 4....
Many people struggle to find out the way on how they can work faster while working on MS Excel/Access or VBA. let me share the tip for that. If you are new or working since long time on Excel/Access...
Nested If statements are complicated to type down and include many parameters. The best method to replace them is to use the lookup function. Using the lookup function shortens the formula at a considerable...