Create V lookup column to identify unique number sequence in 1 list to another

Copper Contributor

Hi

 

I currently have 2 sharepoint lists

 

In the first list, entries include a unique numerical sequence in 1 column (ISRC column) 

 

In the second list, there is also a column where users will input in a unique numerical value (ISRC column).  On this list, there is a task that will be set to Complete and what i'm trying to do is create a V Look up on List 1, that will identify when there is a numerical value match and include the status value of Complete in a look up column.  

 

I understand that Look up columns cannot work with Choice fields in sharepoint so I created a separate 'Calculated' column which just duplicated the 'Complete' text from the status update column (The 'Is Monetised? column shown below in list 2).   It's this Calculated column value that I need to map to list 1 when there is a numerical value match.  my current set up is not working however, not sure where I am going wrong?

 

any help much appreciated

 

thanks

 

List 1 - 

chuck12341000_2-1616588926815.png

 

 

List 2 - monetisation

chuck12341000_1-1616588855830.png

 

My look up column settings

chuck12341000_0-1616588821600.png

 

0 Replies