Forum Discussion

excel_learner's avatar
excel_learner
Brass Contributor
Sep 22, 2021

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

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    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.

Resources