I am facing the issue in vlookup formula once I put the formula in cell some cell pick the values and some cells are not picking the value even the find the name is same...
kindly help me
There may be space characters in the column you are trying to match.
If not, you might want to check the Range as well
I guess the first column of the table_array argument of your VLOOKUP has leading, trailing, or extra spaces. In such a case, you may use TRIM in LOOKUP, like this: