troubleshooting Question

EXCEL 2007

Avatar of W.E.B
W.E.B asked on
Microsoft SQL Server 2005Microsoft OfficeSpreadsheets
6 Comments1 Solution335 ViewsLast Modified:
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$3:$E$206) to only get the value of sales (without even the formula), but the results are coming wrong.
Any help is appreciated.


Sales-Comparison.xls
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros