Scenario I have a current list of names which are entries for a national 8Ball tournament. I have a list of names with a ranking I am trying to establish what each players national ranking is & who is missing from the list and as yet doesn't have a ranking. The problem I have encountered is that it picks up most of the names but some that are present get missed and I cannot find a difference in the text. I have checked for extra spaces etc there aren't any. It has me baffled.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Does the Vlookup function in excel work with text?
- Thread starter Magdella
- Start date
mikerickson
MrExcel MVP
- Joined
- Jan 15, 2007
- Messages
- 24,355
VLOOKUP is not case sensitive.
One thing that catches me is if the lookup_range uses relative referencing and I drag it..... oops.
What is the formula that is bringing you inconsistent results?
One thing that catches me is if the lookup_range uses relative referencing and I drag it..... oops.
What is the formula that is bringing you inconsistent results?
Upvote
0
Similar threads
- Solved
