Forum Discussion
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...
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)
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)
- I have this same problem but I'm literally dragging the formula down (after removing the $ so. It will pull correctly). When I did this earlier today, it worked. Now I get n/a. If I reenter my formula and drag it again it works for 6 or so rows then goes back to n/a. Any ideas?
OliverScheurich thank you so much!!! it worked 🙂
