CODEWITHSUNDEEP
excelexcel-formulavlookup
Emna
Emna

Reputation: 63

VLOOKUP wrong result and sort the result

I have a problem with the vlookup, I sure that I use the function correctly, but I have a wrong result.

enter image description here

enter image description here

I tried also this code, and i have the same problem:

INDEX('F-CLIENT'!B$2:B$426;EQUIV(Feuil1!C4;('F-CLIENT'!A$2:A$426)))

For exemple: for the Code "E032" I must have this result

enter image description here

Upvotes: 0

Views: 190

Answers (1)

G42
G42

Reputation: 10019

It looks like this has been resolved for OP in the comments but there is no explanation of the feature.

VLOOKUP arguments

Resolution: Specify the optional range_lookup argument at the end of your vlookup Assign it to FALSE (or 0) to perform an an Exact match.

Why: It is TRUE (or 1) by default. This performs an Approximate match.

Check out the MSDN documentation on VLOOKUP which provides more information on what this does with examples.

Upvotes: 1

Related Questions