Forum Discussion
Getting a value from another table using a lookup value and date comparison
Hello, I've provided the image below to better illustrate my needs, but I'm having issues getting a value from another [non-related] table using a single lookup value as well as checking to see if a...
This is very, very helpful. Thank you.
My only issue now is that I get an error that too many results were returned, even though I vetted Table2 to confirm that is no overlap in dates (it's only ~100 rows). I should have mentioned that the Table1.Date value should be unique in Table2, but Table2.LookupValue has many (but with differing date ranges).
I think I got confused, what is the unique value that joins the two tables together?
Can LookupValue appear more than once in either table - is it not unique?