Forum Discussion
Vlookups formula
Hello all, Im trying to get different values back in a certain cell after depending on what i put in another cell. I have used a vlookup formula for this but keep getting #N/A Anyone have any idea...
Remedy:
Mark the column -> right mouse button -> format cells ->
select standard or 'Number' (even if that should already be the case)-> OK.
Leave selected -> data -> text in columns -> finish.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.
Mark the column -> right mouse button -> format cells ->
select standard or 'Number' (even if that should already be the case)-> OK.
Leave selected -> data -> text in columns -> finish.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.