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. Vlookup gives inaccurate output if the Lookup table range is huge.