Sep 29 2020 11:18 AM
Hi ,
When I'm trying to use the V lookup I'm getting N/A for same value .e.g
I have used everything same, used trim and Len formula. Any suggestion?
Sep 29 2020 11:53 AM
It is said that a picture is worth a thousand words, but in the case of the Excel it is certainly not the most helpful.
If I can recommend you, add a file (without sensitive data) and explain your plan by adding something to your question in the file.
This means that you can be helped faster and more accurately and it is made easier for the helpers to offer you a tailor-made solution.
In theory, there can be many sources of error, but to be sure you need the file, otherwise you have to guess.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
Sep 29 2020 12:34 PM
First of all try simply compare the cells you lookup, like =cell1=cell2. If FALSE, something is wrong with your data. If TRUE, formula is incorrect.