Excel formula VLOOKUP() with text
cariv
-
leslie -
leslie -
Hello everyone,
I'm having some difficulties with a table in Excel using the VLOOKUP() function with text.
Let me explain:
I have a column A with alphanumeric references like A334354354.
I need to perform a lookup on this reference.
-- > I write =VLOOKUP(A1, BASE, 5) to look up the reference in the database called BASE to get a stock quantity located in column 5.
I'm getting unreliable results. This is due to column A (references) being in text format.
Is there a function that can help bypass this problem?
Thank you in advance for your informed advice.
I'm having some difficulties with a table in Excel using the VLOOKUP() function with text.
Let me explain:
I have a column A with alphanumeric references like A334354354.
I need to perform a lookup on this reference.
-- > I write =VLOOKUP(A1, BASE, 5) to look up the reference in the database called BASE to get a stock quantity located in column 5.
I'm getting unreliable results. This is due to column A (references) being in text format.
Is there a function that can help bypass this problem?
Thank you in advance for your informed advice.
Configuration: Windows XP Internet Explorer 7.0
2 réponses
Hello,
The problem you are encountering is probably due to the fact that the data in column A is not in ascending order, which is a crucial condition for the correct functioning of the VLOOKUP(A1;BASE;5) function.
To remedy this, try VLOOKUP(A1;BASE;5;FALSE)
Have a nice day.
--
http://gerard.g.perso.orange.fr
The problem you are encountering is probably due to the fact that the data in column A is not in ascending order, which is a crucial condition for the correct functioning of the VLOOKUP(A1;BASE;5) function.
To remedy this, try VLOOKUP(A1;BASE;5;FALSE)
Have a nice day.
--
http://gerard.g.perso.orange.fr
After 1 hour of tearing my hair out, I come across your post that saves me! And since the one you helped didn't even thank you, I do it for him:
THANK YOU VERY MUCH