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 answers
-
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 -
