Find value in table matching first column

[lionking001]

I am sure this is a simple answer, but looking for help pulling the first date from simplified table below, regardless of what column it is in. "Tasks" are unique and will only have one date attached to it, but dates may change columns. I want to return the date in my query.

Data:

	Week 1	Week 2	Week 3	Week 4	Week 5
Task 1	11/1/2021​
Task 2		11/8/2021​
Task 3		11/8/2021​
Task 4				11/22/2021​
Task 5					11/29/2021​

What is the formula I can use for column B here to get the dates in the table but account for unknown column number in source data. ?

Task	Deadline
Task 3	11/9/2021​
Task 5	11/29/2021

 

[DanteAmor]

Hi and welcome to MrExcel.

Try this:

Dante Amor
	A	B	C	D	E	F
1		Week 1	Week 2	Week 3	Week 4	Week 5
2	Task 1	01/nov/2021
3	Task 2		08/nov/2021
4	Task 3		08/nov/2021
5	Task 4				22/nov/2021
6	Task 5					29/nov/2021
7
8	Task	Deadline
9	Task 3	08/nov/2021
10	Task 5	29/nov/2021
Hoja2

Cell Formulas
Range	Formula
B9:B10	B9	=SUMPRODUCT(($A$2:$A$6=A9)*($B$2:$F$6))

 

[lionking001]

Hi and welcome to MrExcel.

Try this:

Dante Amor
	A	B	C	D	E	F
1		Week 1	Week 2	Week 3	Week 4	Week 5
2	Task 1	01/nov/2021
3	Task 2		08/nov/2021
4	Task 3		08/nov/2021
5	Task 4				22/nov/2021
6	Task 5					29/nov/2021
7
8	Task	Deadline
9	Task 3	08/nov/2021
10	Task 5	29/nov/2021
Hoja2

Cell Formulas
Range	Formula
B9:B10	B9	=SUMPRODUCT(($A$2:$A$6=A9)*($B$2:$F$6))

Hmm, this is showing me a #VALUE error

Not sure if it makes a difference but the dates I am pulling from the table are built off formulas calculating the date.
Any way to vlookup column A and pull the date without defining the column #?

 

[DanteAmor]

Not sure if it makes a difference but the dates I am pulling from the table are built off formulas calculating the date.

I don't understand how you get the dates. If the result of the formula is a date or a "", then try this array formula.

Dante Amor
	A	B	C	D	E	F
1		Week 1	Week 2	Week 3	Week 4	Week 5
2	Task 1	01/nov/2021
3	Task 2		08/nov/2021
4	Task 3		08/nov/2021
5	Task 4				22/nov/2021
6	Task 5					29/nov/2021
7
8	Task	Deadline
9	Task 3	08/nov/2021
10	Task 5	29/nov/2021
Hoja2

Cell Formulas
Range	Formula
B9:B10	B9	=MAX(($A$2:$A$6=A9)*(IF(ISNUMBER($B$2:$F$6),$B$2:$F$6)))
Press CTRL+SHIFT+ENTER to enter array formulas.

Any way to vlookup column A and pull the date without defining the column #?

I do not understand what you mean. Your example is not very clear.
You could give an example of what you have and the result you want.
Use the XL2BB tool minisheet (see my signature).

 

[lionking001]

Thank you, that worked!
Sorry that was so unclear, i realize theres probably many ways to get the right answer, so I wasnt sure how to pose the question. But thank you!

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.