Forum Discussion
excel_learner
Sep 22, 2021Brass Contributor
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
- NikolinoDEPlatinum ContributorRemedy:
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.