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