Lookup Syntax Seems to be bit off for me in the above script.
Can you try to use like the below :
lookup(field_name, match_field_name, match_field_value [, table_name])
put the table name as well please and also
for ChefNr = 141 how many different values exist in table [Sheet1$_a3b33b80-6a51-0727-b43f-226dc5b0] ?
if there are more than 1 value is matching in the source table for 141 and 102 we may not get the correct results .
Hi, thank you for the reply, using the table name
Lookup('Sheet1$-3.Namn','Anstnr-VismaAktörId',[ChefNr],'[Sheet1$_a3b33b80-6a51-0727-b43f-226dc5b0]') as ChefNamn //test still does not provide the missing values. There is also only 1 entry for both of the missing values, i.e only on occurence of 102 and 141.