Column search between two lists

Copper Contributor

good morning group

 

I appreciate your help with the following:

 

I have a SharePoint list “AppCorreos”

another list “WMInforme”

Both lists have a column "NitFactura"

 

I need to create in "AppCorreos" a Column "RadicadoWM" in which:

 

If "NitFactura" from the "AppCorreos" list = "NitFactura" from the "WMInforme" list, in this new column "RadicadoWM" from the "AppCorreos" list, write me what is in the "Cod_Barras" column from the " WMInforme”

 

I have tried inserting the column with the "Search (information already available on this site)" feature, but it always gives me a syntax error

 

I thank you in advance for the help.

2 Replies
1