Forum Discussion

Patrick Burger's avatar
Patrick Burger
Copper Contributor
Nov 18, 2018

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.

Resources