Index/Match Multiple Criteria & Multiple Columns

[SkiliedSin]

Hello,

So I have criteria A (Name) & criteria B (Date) and I want to pull the number associated with both of these criteria across multiple columns.

I've attached a screenshot showing what I am looking for.

I want to change the value in A or B to either a different name or date and it'll spit out the number from the corresponding columns to the right.

 

[AhoyNC]

Try:

Book1
	A	B	C	D	E	F	G	H	I
1						2021	2020	2019	2018
2	Jacob	2021	5		Jacob	5	4	1	2
3	Jacob	2020	4		Mike	25	6	2	3
Sheet1

Cell Formulas
Range	Formula
C2:C3	C2	=INDEX($F$2:$I$3,MATCH(A2,$E$2:$E$3,0),MATCH(B2,$F$1:$I$1,0))

 

[SkiliedSin]

Try:

Book1
	A	B	C	D	E	F	G	H	I
1						2021	2020	2019	2018
2	Jacob	2021	5		Jacob	5	4	1	2
3	Jacob	2020	4		Mike	25	6	2	3
Sheet1

Cell Formulas
Range	Formula
C2:C3	C2	=INDEX($F$2:$I$3,MATCH(A2,$E$2:$E$3,0),MATCH(B2,$F$1:$I$1,0))

This is perfect, you rock! Thank you!

 

[AhoyNC]

You're welcome. Thanks for the feedback.

 

[SkiliedSin]

Quick bump, if I wanted to add another column as a lookup value how would I go about this?

 

[AhoyNC]

How about an example of what you are looking for. Do you want to return data from 2 columns for a single name?
Also, what version of Excel are you using?

 

[Fluff]

You have already started a new thread for this question, so I am locking this in accordance with Rule#12