how to look up values with two independent variables

B

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)
 
D

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

Bob Phillips

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

--
HTH

Bob Phillips

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