| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return column number from column header text
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Return column number from column header text
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Return column number from column header text
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Return column number from column header text
=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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup first & last values within row & return column header value | Excel Discussion (Misc queries) | |||
| Return text in Column A if Column B and Column K match | Excel Worksheet Functions | |||
| Rank and return column header | Excel Discussion (Misc queries) | |||
| column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) | |||
| Return Column header, if row value is > X | Excel Discussion (Misc queries) | |||
![Roger[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
