Hello! I have a small problem, i have 2 sheets and i want to copy the values from sheet 2 (column B) in sheet 1, only if the client code matches. Basically, i want to transfer the "sum" from sheet 2 to correspund with the right client code in sheet 1. I've tryed =INDEX(Sheet2!B2:B332,MATCH(A2,Sheet2!A2:A332,0)) but seems to not work.
Any suggestions ? What i'm doing wrong ?
Thanks in advance!