CODEWITHSUNDEEP
excelvlookup
Niko.K
Niko.K

Reputation: 307

Vlookup not matching what it should

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

Upvotes: 1

Views: 156

Answers (1)

G42
G42

Reputation: 10019

Change the last argument (range_lookup) to false, or 0. Otherwise you are asking for an approximate match.

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

Upvotes: 1

Related Questions