Here is what I am attempting: On worksheet 2, I want to reference worksheet
one looking at 2 variables. What I want is to reference column D if columns
I and K meet my criteria. Column I has salespeople, so text is repeated
throughout. Column J is dates. Column B is products.

I want to find a formula that will keep up with changes in data.

Please help!!!

Guessing from these lines ..:

In Sheet2,
Assuming you have the dual criteria values for col I and K listed in A2:B2
down
In C2, array-enter (press CTRL+SHIFT+ENTER):
=INDEX(Sheet1!D$2:D$100,MATCH(1,(Sheet1!I$2:I$100=A2)*(Sheet1!K$2:K$100=B2),0))
then copy C2 down as far as required. Adapt the ranges to suit the max
expected extents of data in Sheet1.

I am only getting one result, and it is repeating in the copied cells. I can
llok and see that there is more than 1 result, but they are not coming up.

"Max" wrote:

Ah, you've now introduced a new dimension, multiple results*. What I gave
was an option based on my guesses from the lines that you posted here. Check
the response given in your other posting, where you had described it
differently.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"I M Desperate!!!" discussions.microsoft.com> wrote in message
news:70CD1A91-B56D-4576-A2E2-D33319A7FDE6@microsoft.com...