Help! Need to lookup referencing 2 variables
 

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

Help! Need to lookup referencing 2 variables
 

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Help! Need to lookup referencing 2 variables
 

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:

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Help! Need to lookup referencing 2 variables
 

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!!!" wrote in message
...
I am only getting one result, and it is repeating in the copied cells. I
can
look and see that there is more than 1 result, but they are not coming up.