Forum Discussion
IF and LOOKUP for multiple values
Hi, I have two tables, spend table and contract table similar to the below normalised data I have linked the two tables by Vendor ID and have a dim-date (calendar) table. This may be two issues...
Hi Anonymous ，
The reason for your problem is that your contract table has duplicate data and returns multiple statuses when vendor id=173153. As shown in the red line below, eliminating the duplicate data from the table will resolve the error.
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien