We have to use the function "EXACT"...
See below,
Featured Post
VLOOKUP or INDEX MATCH.. Which one is better?
In the office, my co-worker told me he couldn't get state of Ranking 1 by using VLOOKUP. I recommended INDEX and MATCH combination func...
In the office, my co-worker told me he couldn't get state of Ranking 1 by using VLOOKUP. I recommended INDEX and MATCH combination func...
No comments:
Post a Comment