Filter by Tags

Vlookup not matching what it should

Votes

0

0 0
This Question is asked to:

What I am trying to do is simple and therefore it confuses me why does not work so my plan is to compare two columns in excel and display the match in a separate Colum a typical vlookup exercises.


My issue is that does not match correctly only on the first one is correct.


Column D First Sheet


+-------+
| ColD |
+-------+
| SA212 |
| SA912 |
| . |
| SA211 |
+-------+

Column A Second Sheet


+-------+
| ColA |
+-------+
| SA212 |
| SA912 |
| . |
| SA211 |
+-------+

My Vlookup:


=VLOOKUP(D:D;Table_owssvr[Project number];1)

What happens is simple that the the "matches" are not right instead of matching SA212 to SA212 it matches it to SA912 etc

Sanampreet Aulakh
Posted on : Wed, Jun 21, 2017
Views : 155
Comments

Ask Question

If you want to ask question you must LogIn or SignUp
Login SignUp
To Add your Answer Please
LogIn | SignUp

Quick Links

E-Magazines

@

Total Followers
Study Group Created
Study Group Joined
Following Teacher
Following Organization
Blog Articles Added
Questions Asked
Questions Answered
Jobs Posted
Total Members in Group
Questions asked by members
Tasks added in this Group

Please wait..

Ok

Login to Open ESchool OR Create your account    Login   SignUp