In this Post we will see Five Main Reason why your vlookup may not be working.
we talk about some error which occurs when we applying Vlookup and step by step procedure to fix the issue:
1.Extra Spaces in Lookup Value : This is one of the most common reasons behind the #NA error in VLOOKUP. Leading or trailing spaces in lookup values that cause the VLOOKUP function to not find the match and return #NA error. To remove this error we use the TRIM function to remove trailing and leading spaces.
2. Cell referencing Changes: This error occurs when lookup array referencing changes when the formula is a copy or dragged, to avoid this error we should use $ sign to fix the table array, or Method to fix is also called absolute cell reference or references.
3. Table Contains Duplicates: What happens when lookup value is present multiple times in table array, in such case VLOOKUP returns the first match value based on the column index number entered in the formula.
4. LOOKUP with incorrect range references: VLOOKUP will return a #REF! error because it’s looking for a value to return from column , but the reference range is less in number or this error occurs when we copy any foumula and corresponding vlookup arguments location is not available or deleted. To avoid such errors we should look for the arguments given and should check whether the cell value , table array is actually present.
5. Decimal Value in Lookup value or table array, This error occurs when either lookup value or lookup table value is in number and it has rounded up or down, when excel tries to exact match the decimal value. To avoid this we should check once exact value of lookup value in formula bar.