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