am I understanding you right?
The picture is the desired outcome, and NOT what you are getting?
Just to make sure.Unfortunately I don't see the problem from here either. Tis should be possible with the Lookup-Function. As long as there is an exact match in the second dataset.
But maybe the problem is in the details. I am not exactly sure in which columns you put which formula. Could you show that somewhat clearer
Andreas Wolter | Microsoft Certified Master SQL Server
Blog: www.insidesql.org/blogs/andreaswolter
Web: www.andreas-wolter.com
No comments:
Post a Comment