•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?
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]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel compatibility
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#rows.com
#Vlookup
#function
#Rank
#Excel
#USA
#Brazil
#error
##N/A
#range
#table
#countries
#fix
#support
#chosen
#select
#work