how to look up values with two independent variables

  • Thread starter Thread starter Guest
  • Start date Start date
=INDEX(rng3,MATCH(1,(rng1=val1)*(rng2=val2),0))

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
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.
 
.... an .... <g>

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to set up a simple variable in Excel, but cell location independent 3
How to create a bubble chart with more than 2 variables 0
Find a single value from tables by selecting two variable inputs? 8
Converting an Excel Model into a Function 3
regression results without using the wizard 1
How to record changing value of a cell 1
Merge two worksheets into one with same independent variable 1
Independent Games Festival 2019 finalists 2

Back
Top