Forum Discussion

Lena_Chatchatrian's avatar
Lena_Chatchatrian
Copper Contributor
Oct 20, 2023
Solved

Vlookup only works halfway and rest is #N/A

Hi everyone,   So I'm having this issue lately with documents that I export from our ordering/Bookkeeping system. I want to use vlookup to see which client has ordered which amount of product X and...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Oct 20, 2023

    Lena_Chatchatrian 

    I'd guess that the $ signs are missing in the matrix of VLOOKUP. Which means you have something like

    =VLOOKUP(A2,E2:F22,2,FALSE)

    instead of

    =VLOOKUP(A2,$E$2:$F$22,2,FALSE)

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Oct 20, 2023

Lena_Chatchatrian 

I'd guess that the $ signs are missing in the matrix of VLOOKUP. Which means you have something like

=VLOOKUP(A2,E2:F22,2,FALSE)

instead of

=VLOOKUP(A2,$E$2:$F$22,2,FALSE)

Resources