Formula to check the header name and return the cell data for a specific row

[bb19august]

Excel formula for the following condition given in the table

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]F1[/TD]
[TD]F2[/TD]
[TD]F3[/TD]
[TD]R1[/TD]
[TD]R2[/TD]
[TD]R3[/TD]
[TD]Check[/TD]
[TD]Result[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]F1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD]R3[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]F2[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]R3[/TD]
[TD]0[/TD]
[/TR]
</tbody>[/TABLE]

"Check" column has the header name to be verified and return the cell value in row in the "Results" column
If the cell is blank for a specific header then return '0"

 

[Fluff]

Re: Need help with a formula to check the header name and return the cell data for a specific row

How about

Excel 2013/2016
	A	B	C	D	E	F	G	H
1	F1	F2	F3	R1	R2	R3	Check	Result
2	1	2	1	1	2	1	F1	1
3	1	2	2	1	2	2	R3	2
4	1	2	2				F2	2
5	1	1		1			R3	0
Dashboard

Cell Formulas
Range	Formula
H2	=INDEX($A$2:$F$5,ROWS($1:1),MATCH(G2,$A$1:$F$1,0))

 

[bb19august]

Re: Need help with a formula to check the header name and return the cell data for a specific row

Perfecto. Result as expected. Thank you so much for your time and help

 

[Fluff]

Re: Need help with a formula to check the header name and return the cell data for a specific row

Glad to help & thanks for the feedback