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

%3CLINGO-SUB%20id%3D%22lingo-sub-2232299%22%20slang%3D%22en-US%22%3ECreate%20V%20lookup%20column%20to%20identify%20unique%20number%20sequence%20in%201%20list%20to%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2232299%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20currently%20have%202%20sharepoint%20lists%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20first%20list%2C%20entries%20include%20a%20unique%20numerical%20sequence%20in%201%20column%20(ISRC%20column)%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20second%20list%2C%20there%20is%20also%20a%20column%20where%20users%20will%20input%20in%20a%20unique%20numerical%20value%20(ISRC%20column).%26nbsp%3B%20On%20this%20list%2C%20there%20is%20a%20task%20that%20will%20be%20set%20to%20Complete%20and%20what%20i'm%20trying%20to%20do%20is%20create%20a%20V%20Look%20up%20on%20List%201%2C%20that%20will%20identify%20when%20there%20is%20a%20numerical%20value%20match%20and%20include%20the%20status%20value%20of%20Complete%20in%20a%20look%20up%20column.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20understand%20that%20Look%20up%20columns%20cannot%20work%20with%20Choice%20fields%20in%20sharepoint%20so%20I%20created%20a%20separate%20'Calculated'%20column%20which%20just%20duplicated%20the%20'Complete'%20text%20from%20the%20status%20update%20column%20(The%20'Is%20Monetised%3F%20column%20shown%20below%20in%20list%202).%26nbsp%3B%20%26nbsp%3BIt's%20this%20Calculated%20column%20value%20that%20I%20need%20to%20map%20to%20list%201%20when%20there%20is%20a%20numerical%20value%20match.%26nbsp%3B%20my%20current%20set%20up%20is%20not%20working%20however%2C%20not%20sure%20where%20I%20am%20going%20wrong%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eany%20help%20much%20appreciated%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EList%201%20-%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22chuck12341000_2-1616588926815.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F266650i4199AD7D61882A62%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22chuck12341000_2-1616588926815.png%22%20alt%3D%22chuck12341000_2-1616588926815.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EList%202%20-%20monetisation%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22chuck12341000_1-1616588855830.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F266649i577DE33C4C4F4AE2%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22chuck12341000_1-1616588855830.png%22%20alt%3D%22chuck12341000_1-1616588855830.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20look%20up%20column%20settings%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22chuck12341000_0-1616588821600.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F266648iBEB355AC871F67FF%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22chuck12341000_0-1616588821600.png%22%20alt%3D%22chuck12341000_0-1616588821600.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2232299%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

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