Hello,

I have run into a problem.

I need to check if my ItemCode-cell = an ItemCode-cell in another document. If true, it should write from a cell in the other document. If false, it should just be blank.

I have tried this:
Formula: copy to clipboard 
=IF(EXACT([@ItemCode];'Vareliste 21-06-2012.xlsx'!Table_SsdQL_ET_SBO_ACCOUNT_ATTR[ItemCode]);'Vareliste 21-06-2012.xlsx'!Table_SsdQL_ET_SBO_ACCOUNT_ATTR[@[Konk. Pris]];"")


If the ItemCode in Document 1 = any ItemCode in 'Vareliste 21-06-2012.xlsx', it should write the 'Konk. Pris' cell text from the row that contains the proper ItemCode. If there is no ItemCode match, then just "".

What am I doing wrong?

Thanks,
Patrick