•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How do I fix my Vlookup function to work normally?
Our take
Struggling with your VLOOKUP function can be frustrating, especially when it yields unexpected results like showing Rank 9 for the USA or returning #N/A for Brazil. These issues often stem from range selection or mismatched data types. By refining your formula and ensuring your lookup range is correctly set, you can unlock the accurate insights you need. Continue reading to discover practical steps to fix your VLOOKUP function, streamline your data analysis, and regain confidence in your spreadsheet skills.
Hello,
I was creating a vlookup function that finds Rank accordingly to the table with different countries. In the photo, you can see my function and other components.
The error is, when I choose USA, instead of Rank 1, it shows 9, and when I choose Brazil, excel shows #N/A. I am not sure what is wrong with the function or range that I selected.
I appreciate all your support.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience