Forum Discussion
LOOKUPVALUE Randomly Returns Blank Values
I have a dataset with Names of volunteers and each one is given a unique ID number. In another table, I have some contacts and in that table, there is a column of with the Volunteer ID of the volunt...
vanessafvg I checked and rechecked the Volunteer IDs and they are all distinct values. Now some of the names are the same but that shouldn't matter.
It's the same ones happening over and over again. Even tried it on a different computer to see if there was a cache issue but same exact results.
darshp1have you tried to create a relationship between the two tables between the fields instead of a lookup.