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 ideas ?

1 Reply
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.

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.