| Re: Help! Need to lookup referencing 2 variables |
|
 |
|
 |
|
 |
|
 |
Group: microsoft.public.excel.worksheet.functions · Group Profile
Author: I M Desperate!!!I M Desperate!!! Date: Jun 16, 2008 12:28
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
> ---
>
| 
