Finding the column number

[j3andc]

I am looking for a way to find the column number where a value can be found in a single row range. For example in range F3:Q3, a single value can be found in L3. I need the formula to return the number 7. I would then copy this formula down so I can perform the same calculation throughout the table.

Any help would be greatly appreciated.

Jim

 

[Joe4]

Are you looking for a specific value, or just a non-blank value?
Which column will the formula go in?

 

[Scott T]

	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P

<COLGROUP><COL style="BACKGROUND-COLOR: rgb(218,231,245)"><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP><THEAD>
</THEAD><TBODY>
[TD="align: center"]3[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"][/TD]

</TBODY>

Sheet1​

[TABLE="width: 85%"]
<TBODY>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<THEAD>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</THEAD><TBODY>[TR]
[TH="width: 10, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D3[/TH]
[TD="align: left"]=MATCH("g",F3:U3,0)[/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[/TR]
</TBODY>[/TABLE]

Replace "g" what you are looking for

 

[j3andc]

Thanks. That did it!