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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies