=MATCH("Frank",[Book3]Sheet2!$1:$1,0)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Roger" wrote in message ...
| On Feb 15, 10:00 am, Roger wrote:
| On Feb 15, 9:35 am, "Niek Otten" wrote:
|
|
|
| =MATCH("Frank",1:1,0)
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "Roger" wrote in ...
|
| | 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
|
| This nailed it thanks
| And to think I've been looking at the use of 'Match' in other formulae
| - DOH!
| Can't see the forest for the trees syndrome I suspect.
|
| Thanks Niek
|
| Actually, now I need to be able to look for this information FROM
| another spreadsheet.
| How do I do that?
| Regards
| Roger