Hello,
When I use the function VLOOKUP (Cerca.vert in my language) it doesn't give me the correct result.
What am I doing wrong? Thank you
Cattura.PNG
Hello,
When I use the function VLOOKUP (Cerca.vert in my language) it doesn't give me the correct result.
What am I doing wrong? Thank you
Cattura.PNG
This portion CERCA.VERT(B5;E6:G16;2;1) is an approximate match and should be used for ranges but your ranges need to be in ASCENDING order, not descending order. Try to adjust column E into ascending order along with nd the subsequent data in F and G.
Last edited by Sam Capricci; 07-19-2021 at 11:12 PM.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Hi;
You want the result of "Call value" to be 12.7 ; 12.6 or another value?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks