Forum Discussion
Patrick Burger
Nov 18, 2018Copper Contributor
Trouble with vlookup
I cannot begin to explain my problem. Everything worked until I added a new column to my lookup table. Now anything after the first line retrieves a #N/A when it looks for my data. The date is there it finds the rest of it. But if it moves to a new line, that data seems to no longer be accessible. It's a repeatble form I just don't want to have to fill out again and again. So I want to use vloomup and a source table instead. This was anytime I need the information. It's right at my fingertips.
Let me know what you need for information. I can send the spreadsheets as well.
Thanks in advance.
Also this is office 2016.
Let me know what you need for information. I can send the spreadsheets as well.
Thanks in advance.
Also this is office 2016.
- Arul TresoldiIron Contributor
If you send us the file we can check if all parameters are set good.