Help! Need to lookup referencing 2 variables

  • Thread starter Thread starter I M Desperate!!!
  • Start date Start date
I

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!!!
 
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: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.
 
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.
 
Back
Top