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

F1	F2	F3	R1	R2	R3	Check	Result
1	2	1	1	2	1	F1	1
1	2	2	1	2	2	R3	2
1	2	2				F2	2
1	1		1			R3	0

<tbody>
</tbody>

"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