Customer Product Jan-04 Feb-04 Mar-04 Apr-04
U Trial BC EV
U Trial ABC Trial
U Trial DEG 1130 2 3
U Trial ABC 1180 1
MII Trial RLJ 2
MII Trial KLW
MII Trial DE
MII Trial DEG 1130 3 1
MII Trial ABC EV-Trial 9 4
MII Trial ABC Card 1 2
"Biff" wrote:
Hi!
This is relatively easy to do but it would help if you
could post a sample of your data and explain what data
you're trying to extract.
Biff
-----Original Message-----
My initial spreadsheet contains a table of information, I
am trying to create
a new spreadsheet with a cleaner version of the
information. I am trying to
use the INDEX and MATCH functions; however, to return my
values I must
consider three constants: customer, product, and date.
So far I have only
been able to find a way to use two constants. All three
must be considered
because many customers purchase a variety of products.
The date is
horizontal while customer and product are both vertical.
.
|