I use vlookup formula to assign a parameter for the first column entries, and do not get any results, but a formula written instead:
=VLOOKUP(A2;$L$2:$M$554;2;FALSE)
What can be a problem?
vlookup problem



I hope I have understood your problem
Goto ToolsOptionsView from the menu
Under the Window Options area, is the Formulas checkbox checked? If so, uncheck the box & click on OK. You should now see the results of the formula as opposed to the formula itself

Quote from WillR
I hope I have understood your problem
Goto ToolsOptionsView from the menu
Under the Window Options area, is the Formulas checkbox checked? If so, uncheck the box & click on OK. You should now see the results of the formula as opposed to the formula itself
The Formulas checkbox is unchecked, but the problem is still there. I paste a bit of a table here. Maybe this will give better view about the data:
SERIES Result
3706000 =VLOOKUP(A2;$L$2:$M$554;2;FALSE)
3706002
3706003
3706004
3706010
3706760
etc.Value table:
Series Type
3706000 Post
3706001 Post
3706002 Post
3706003 Post
3706004 Pre
etc.
The entries in the Result column should get a value "post" or "pre"I attached the file.

Can you attach a file showing the data  I am pretty sure it's the cell formatting

Hi, Eagle
I wonder if the formula right?
I'm using comma, NOT SEMICOLON, as a separater like:
=VLOOKUP(A2,$L$2:$M$554,2,FALSE)If it doesn't help, would you check the cell format?
When you set "Text" on that cell, it looks like that.
You need to set it back to General and also go back to the cell and enter once.
I hope that will give you the right answerJindon


I changed the formats of the columns and it worked! Thank you, jindon!
WillR, thank you too!Best regards,
Egle
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!