=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
...

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

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

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