SearchV not returning the correct value
Solved
Elcaprio
Posted messages
73
Status
Membre
-
Elcaprio Posted messages 73 Status Membre -
Elcaprio Posted messages 73 Status Membre -
Hello,
I have a little problem with a VLOOKUP that doesn't always return the searched value.
I am used to using this function, but this is the first time I've seen this!
I named a range "trad".
My VLOOKUP is quite simple: =IF(A7="","",VLOOKUP(A7,trad,5))
However, sometimes instead of returning the value corresponding to A7 in the 5th column of my range, the function returns something else.
I'm not sure I'm being clear, so I'll take a concrete example: (the image is my range "trad")
In A7 on another sheet, I have the value 11011
So theoretically, I should have the content of my cell E3, but instead, I get E28.
On the other hand, if I have the value 1101 in A7 of my other sheet, I do get E2 as a result...
Sometimes it works, sometimes it doesn't... I can't see any logic or recurrence in the errors.
Thank you for your answers
Configuration: Windows 7 / Internet Explorer 9.0
I have a little problem with a VLOOKUP that doesn't always return the searched value.
I am used to using this function, but this is the first time I've seen this!
I named a range "trad".
My VLOOKUP is quite simple: =IF(A7="","",VLOOKUP(A7,trad,5))
However, sometimes instead of returning the value corresponding to A7 in the 5th column of my range, the function returns something else.
I'm not sure I'm being clear, so I'll take a concrete example: (the image is my range "trad")
In A7 on another sheet, I have the value 11011
So theoretically, I should have the content of my cell E3, but instead, I get E28.
On the other hand, if I have the value 1101 in A7 of my other sheet, I do get E2 as a result...
Sometimes it works, sometimes it doesn't... I can't see any logic or recurrence in the errors.
Thank you for your answers
Configuration: Windows 7 / Internet Explorer 9.0
Indeed, adding "0" or "false" is better.