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.