LinkBack URL
About LinkBacks
Hello,
I am using vlookup formula to return values from power query import and by some reason excel is returning random values or zeros instead of the appropriate value.
How to fix this?
Hello,
I am using vlookup formula to return values from power query import and by some reason excel is returning random values or zeros instead of the appropriate value.
How to fix this?
What's the exact formula you are using? Have you set the fourth argument (TRUE or FALSE) at the end of the formula?
Do you really expect us to be able to help with so little information?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Sorry, for being not informative enough.
I am using a VLOOKUP formula.
And no, I have not set the fourth argument, which one should I choose?
the question asked was what was the exact formula, we know you said you used vlookup.
the 4th argument tells excel to look for an exact match in potentially unsorted data (1) or in sorted data, to return the exact or 1-before-exact match (0)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
When you don’t set it the default is TRUE......so if that isn’t working you need FALSEOriginally Posted by kao
When 4th argument is FALSE you will get an exact match only - data doesn’t need to be sorted
Audere est facere
Looks like argument FALSE solved the issue!
Than you!
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks