how to look up values with two independent variables
 

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" wrote in message
...

how to look up values with two independent variables
 

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

"charlesfung" wrote in message
...

how to look up values with two independent variables
 

Bob, of course, is the exception.

--
Don Guillett
SalesAid Software

"Don Guillett" wrote in message
...
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

"charlesfung" wrote in message
...

how to look up values with two independent variables
 

.... an .... <g

--
HTH

Bob Phillips

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

"Don Guillett" wrote in message
...
Bob, of course, is the exception.

--
Don Guillett
SalesAid Software

"Don Guillett" wrote in message
...
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

"charlesfung" wrote in message
...