Help! Need to lookup referencing 2 variables

[I M Desperate!!!]

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!!!

 

[Max]

Guessing from these lines ..:

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.

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$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 M Desperate!!!]

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]

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.