Hi Guys,
Can you check why my Vlookup is not working.
I'm supposed to get 6%, 8%, 10% with the following range value.
The range value supposed to a "From" this value "To" this value.
Formula NA.JPG
Thanks,
Hi Guys,
Can you check why my Vlookup is not working.
I'm supposed to get 6%, 8%, 10% with the following range value.
The range value supposed to a "From" this value "To" this value.
Formula NA.JPG
Thanks,
It's working correctly. Anything less than the first number in the lookup table will return N/A, as there is nothing for it to match with. In other words, with an approximate lookup, your lookup values need to be in ascending order.
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.
The values in cells AD17:AD19 must be in ascending order for your formula to work properly.
Also check that column AB is not being seen as Text. You can use =ISNUMBER(AB2) to check this.
Thanks for the quick answers!
Glad we could help. Thanks for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks