lookup with INDEX MATCH formule depending on 2 conditions

R

Roger Govier

Hi

Not much to go on here. It is lays better to post details of your actual
question in the body of the post.

As a generalisation.
If in cells B1:M1 you had Jan, Feb ..... Dec
If in cells A2:A32 you had the numbers 1 through 31

In cell O1 you Had Jun and in cell O2 you had 5
then
=INDEX($A$1:$M$32,MATCH(O2,$A$1:$A$32,0),MATCH(O1,$B$1:$M$1,0))
would return the value that is in the cell for Jun 5th.

INDEX require 2 inputs, Row and Column.
The first MATCH finds the row number, the second MATCH finds the column
number.
 
E

Excel ESG

Is it possible to lookup values depending on Two conditions

e.g.

Firstname (column A) AND Lastname (B) to lookup address (C)
 
R

Roger Govier

Hi

One way would be the array entered formula, where the values to be
matched are entered in D1 and E1

{=INDEX(C:C,MATCH(D1&E1,A:A&B:B,0))}

To commit or Edit an array formula, use Control,Shift,Enter (CSE) not
just Enter
Do not type the curly braces { } yourself. If you use CSE, Excel
will enter them for you
 
E

Excel ESG

Sorry for the empty post,

I have data in 3 columns where I would find the data depending on the first
two columns
e.g.
firstname (column A), lastname (B) to find adress (C)
 
E

Excel ESG

Sorry for the empty post,

What I am trying to do is this:
Find data in a 3rd column depending on both first two columns e.g.

firstname (A) lasname (B) to find address (C)
 
R

Roger Govier

Obviously a problem with the sever yesterday, as you have not seen my
response.
I repeat it below

One way would be the array entered formula, where the values to be
matched are entered in D1 and E1

{=INDEX(C:C,MATCH(D1&E1,A:A&B:B,0))}

To commit or Edit an array formula, use Control,Shift,Enter (CSE) not
just Enter
Do not type the curly braces { } yourself. If you use CSE, Excel
will enter them for you
 
Top