| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find column letter
Put this in A1:
=IF(ISNA(MATCH(A2,$B$1:$AH$1,0)),"",IF(MATCH(A2,$B $1:$AH $1,0)25,"A"&CHAR(MATCH(A2,$B$1:$AH$1,0)+39),CHAR( MATCH(A2,$B$1:$AH $1,0)+65))) Hope this helps. Pete On Aug 29, 1:38*pm, Stuart WJG wrote: I need a formula that can look for a date in a cell that matchs a date in a range and then enter column letter in the formula cell Formula in A1 Variable cell (date) A2 Range B1:ah6 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
find column letter
Sorry, I thought your range was B1:AH1 - ignore my post.
Pete On Aug 29, 2:29*pm, Pete_UK wrote: Put this in A1: =IF(ISNA(MATCH(A2,$B$1:$AH$1,0)),"",IF(MATCH(A2,$B $1:$AH $1,0)25,"A"&CHAR(MATCH(A2,$B$1:$AH$1,0)+39),CHAR( MATCH(A2,$B$1:$AH $1,0)+65))) Hope this helps. Pete On Aug 29, 1:38*pm, Stuart WJG wrote: I need a formula that can look for a date in a cell that matchs a date in a range and then enter column letter in the formula cell Formula in A1 Variable cell (date) A2 Range B1:ah6- Hide quoted text - - Show quoted text - |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
find column letter
Yeah, I was kind of thinking the same thing - or that the date would be on
one of the rows. But realized he has a whole matrix and I didn't know what was in it. Looks like Gary''s Student has given a solution that should deal with that eventuality although I was kind of hoping to stay away from a UDF myself. "Pete_UK" wrote: Sorry, I thought your range was B1:AH1 - ignore my post. Pete On Aug 29, 2:29 pm, Pete_UK wrote: Put this in A1: =IF(ISNA(MATCH(A2,$B$1:$AH$1,0)),"",IF(MATCH(A2,$B $1:$AH $1,0)25,"A"&CHAR(MATCH(A2,$B$1:$AH$1,0)+39),CHAR( MATCH(A2,$B$1:$AH $1,0)+65))) Hope this helps. Pete On Aug 29, 1:38 pm, Stuart WJG wrote: I need a formula that can look for a date in a cell that matchs a date in a range and then enter column letter in the formula cell Formula in A1 Variable cell (date) A2 Range B1:ah6- Hide quoted text - - Show quoted text - |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
find column letter
See his reply to my question - looks like you gave him good solution anyhow.
"Pete_UK" wrote: Sorry, I thought your range was B1:AH1 - ignore my post. Pete On Aug 29, 2:29 pm, Pete_UK wrote: Put this in A1: =IF(ISNA(MATCH(A2,$B$1:$AH$1,0)),"",IF(MATCH(A2,$B $1:$AH $1,0)25,"A"&CHAR(MATCH(A2,$B$1:$AH$1,0)+39),CHAR( MATCH(A2,$B$1:$AH $1,0)+65))) Hope this helps. Pete On Aug 29, 1:38 pm, Stuart WJG wrote: I need a formula that can look for a date in a cell that matchs a date in a range and then enter column letter in the formula cell Formula in A1 Variable cell (date) A2 Range B1:ah6- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I turn excel columns from column number to column letter? | Setting up and Configuration of Excel | |||
| How to replace column letter in refferences with a function using the old column letter? | Links and Linking in Excel | |||
| How to replace column letter in refferences with a function using the old column letter? | Excel Worksheet Functions | |||
| column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) | |||
| Find column letter containing specific data | Excel Worksheet Functions | |||
Hybrid Mode
