how to look up values with two independent variables

[Bob Phillips]

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

--

HTH

Bob Phillips

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

 

[Don Guillett]

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]

Bob, of course, is the exception.

 

[Bob Phillips]

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

--
HTH

Bob Phillips

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