Return column number from column header text

[Roger]

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

 

[Niek Otten]

=MATCH("Frank",1:1,0)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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

 

[Roger]

=MATCH("Frank",1:1,0)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| 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

 

[Roger]

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

 

[Niek Otten]

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| >
| >
| >
| > > =MATCH("Frank",1:1,0)
| >
| > > --
| > > Kind regards,
| >
| > > Niek Otten
| > > Microsoft MVP - Excel
| >
| >
| > > | 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