Trouble with vlookup

Patrick Burger
New Contributor
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.
1 Reply

If you send us the file we can check if all parameters are set good.

Related Conversations
Custom value if a value is found using vlookup
Sam55 in Excel on
5 Replies
vlookup using concatenate function and helper column
Angela McGhin in Excel on
4 Replies
Vlookup doesn't work for inexplicable reason
Domonkos in Excel on
2 Replies
BowlingAlleyBob in Excel on
3 Replies
Need FORMULA help please!!
marislav in Excel on
4 Replies
Need some help with my Vlookup or a new idee
Jim Brastad in Excel on
5 Replies