not sure what I'm doing wrong,
Here is the requirement, (I'm trying to copmare sales between periods of 2 years)-
Find Client from Column K in Column C, If the client is found, results ,
(SALES in column M - Sales in column E) -- for the client.
I tried to use =LOOKUP(K3,$C$3:$C$206,$E$3:$E$206) to only get the value of sales (without even the formula), but the results are coming wrong.
Any help is appreciated.
this works great, how do you add the formula, to get return as
difference, (SALES in column M - Sales in column E)