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