Return column number from column header text
=MATCH("Frank",1:1,0)
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Roger" wrote in message ...
| Excel 2003
|
| I need to return the column number from a worksheet by searching on
| the text in the column headers.
|
| Example:
| I have simple names in Row 2 of Jim, Frank, Tony which could have
| moved by inserting or deleting a column.
|
| How do I return the column number?
|
| Thanks
|