Look up multiple columns for cell value

[surkdidat]

Hi

I have data in columns A:E. Cell F2 I have a date. What I need is t look at A2:E2 and return either F1 (column header name) or a 0 if f2 value is not in that row.

Many thanks

 

[Tim_Excel_]

=if(ifna(match(f2,a2:e2,0),0)=0,f1)

 

[surkdidat]

This is bringing up false, even though in D2 I have the same value as in F2... Also I need it to bring up the column header of A1:E1 that the value is in... So if it was in D2, I want the answer as D1, if the answer was in E2, I want the anser as E1 (Apologies stated that wrong to begin with)

=if(ifna(match(f2,a2:e2,0),0)=0,f1)

 

[jtakw]

Hi,

Is this what you mean:

Book1
	A	B	C	D	E	F	G
1	Hear A	Hear B	Hear C	Hear D	Hear E
2	12/1/2018	12/2/2018	12/3/2018	12/4/2018	12/5/2018	12/12/2018	0
3	12/10/2018	12/11/2018	12/12/2018	12/13/2018	12/14/2018	12/13/2018	Hear D
Sheet387

Cell Formulas
Range	Formula
G2	=IFERROR(INDEX(A$1:E$1,MATCH(F2,A2:E2,0)),0)

 

[Tim_Excel_]

I would like to point out that using IFERROR instead of IFNA would return a 0 for every error, opposed to only for when the value is not present. This could cause unwanted results in case of unexpected errors other than #N/A