Formula Which Returns Horizontal Field Names

[syedbokhari]

Hey Chaps

I've miss the boards

I am having trouble developing a formula which will return a field (specific cells back to me) based on some conditions.

Basically I want a formula which will return the date (G3-T3) to me on each client. On the conditions of there usage.

So I want it to extract the value of the first number to comes across (the value of the number does not matter).

E.g. Gissle (D5) "The formula should go along and provide me with the date (value) "1/7/2013" [Cell I3) in cell [E5).

It just needs to hit the first value it comes across horizontally and provide me with the date (field) which it is located in Column E (E5-E11).

All help is UBER appreciated as I need this to solve a problem and save at work because I had to manually scope out the first value and insert and copy the date (took an hour).

I hope it is possible

And thanks again Chap!

Excel Workbook
	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
2	*	*	*	Usage	*	*	*	*	*	*	*	*	*	*	*	*	*
3	*	Date	*	1/5/2013	1/6/2013	1/7/2013	1/8/2013	1/9/2013	1/10/2013	1/11/2013	1/12/2013	1/13/2013	1/14/2013	1/15/2013	1/16/2013	1/17/2013	1/18/2013
4	Client	*	*	*	*	*	*	*	*	*	*	*	*	*	8	*	*
5	Giselle	*	*	*	*	*	*	*	*	*	5	*	*	*	*	*	*
6	Elaine	*	*	*	*	*	*	4	*	*	*	*	*	*	*	*	*
7	Lidi	*	*	4	*	*	*	*	*	*	*	*	*	*	*	*	*
8	Eliza	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*
9	Ji	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	4
10	Erika	*	*	*	*	1	*	*	*	*	*	*	*	*	*	*	*
11	Maria	*	*	*	*	*	*	*	*	5	*	*	*	*	*	*	*
12	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*	*
Sheet1

4 </a>

 

[syedbokhari]

Sorry my example is wrong!

For Gissle (D5) "The formula should go along and provide me with the date (value) "1/12/2013" [Cell N3) in cell [E5).

 

[Marcelo Branco]

Try

E5
=IF(COUNT($G5:$T5),INDEX($G$3:$T$3,MATCH(TRUE,INDEX(ISNUMBER($G5:$T5),0),0)),"Not found")
copy down

M.

 

[billszysz]

Hi,

Try this (if i understand correctly)
Cell E5

=IFERROR(INDEX($G$3:$T$3,MATCH(TRUE,ISNUMBER(G5:T5),0)),"")

CTRL+SHIFT+ENTER

 

[syedbokhari]

Thanks guys!

It worked well! I would like to donate to a charity on your behalf!

If you have one PM ME and by all means I will donate 10-15 dollars to it as it helped so much!