asked on
EXCEL 2007
Hello,
not sure what I'm doing wrong,
Here is the requirement, (I'm trying to copmare sales between periods of 2 years)-
--Column H--
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$
Any help is appreciated.
Sales-Comparison.xls
not sure what I'm doing wrong,
Here is the requirement, (I'm trying to copmare sales between periods of 2 years)-
--Column H--
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$
Any help is appreciated.
Sales-Comparison.xls
Microsoft SQL Server 2005Microsoft OfficeSpreadsheets
Last Comment
W.E.B
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Try this:
=M3-INDEX(E:E,MATCH(K3,C:C
That will return a #N/A error if K3 has no match in Col C. If you want <Sales in Col E> treated as zero if there is no match:
=M3-IFERROR(INDEX(E:E,MATC
Patrick
=M3-INDEX(E:E,MATCH(K3,C:C
That will return a #N/A error if K3 has no match in Col C. If you want <Sales in Col E> treated as zero if there is no match:
=M3-IFERROR(INDEX(E:E,MATC
Patrick
ASKER
Perfect,
I will be using both for different reports,
thanks.
I will be using both for different reports,
thanks.
ASKER
sorry, accepted my own , instead of Patrick.
ASKER
Excellent
=INDEX(E:E,MATCH(K3,C:C,0)
this works great, how do you add the formula, to get return as
difference, (SALES in column M - Sales in column E)
thanks,