how to look up values with two independent variables

=INDEX(rng3,MATCH(1,(rng1=val1)*(rng2=val2),0))

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"charlesfung" <[email protected]> wrote in message
news:[email protected]...
>

Many of us will not respond to a post where you don't take the time to fully
explain your problem in the body of the post instead of a simple subject
line.

--
Don Guillett
SalesAid Software
[email protected]
"charlesfung" <[email protected]> wrote in message
news:[email protected]...
>

Bob, of course, is the exception.

--
Don Guillett
SalesAid Software
[email protected]
"Don Guillett" <[email protected]> wrote in message
news:[email protected]...
> Many of us will not respond to a post where you don't take the time to
> fully explain your problem in the body of the post instead of a simple
> subject line.
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "charlesfung" <[email protected]> wrote in message
> news:[email protected]...
>>
>
>

.... an .... <g>

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Don Guillett" <[email protected]> wrote in message
news:[email protected]...
> Bob, of course, is the exception.
>
> --
> Don Guillett
> SalesAid Software
> [email protected]
> "Don Guillett" <[email protected]> wrote in message
> news:[email protected]...
> > Many of us will not respond to a post where you don't take the time to
> > fully explain your problem in the body of the post instead of a simple
> > subject line.
> >
> > --
> > Don Guillett
> > SalesAid Software
> > [email protected]
> > "charlesfung" <[email protected]> wrote in message
> > news:[email protected]...
> >>
> >
> >
>
>