lookup with INDEX MATCH formule depending on 2 conditions

[Guest]

--
Shared knowledge makes you smarter

 

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

 

[Guest]

Is it possible to lookup values depending on Two conditions

e.g.

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

 

[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

 

[Guest]

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)

 

[Guest]

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)

 

[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