| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for Column Number
Is there any way to find out the column number within an array that matches
with the lookup value like the "Match" Function? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula for Column Number
If you post your actual scenario, you'll get a more tailored response.
Absent that.....here's one way: With A1: (a value to lookup) C1:Z1 contains values This formula returns the column number of the first item in C1:Z1 that matches A1 B1: =MATCH(A1,C1:Z1,0)+COLUMN(B1) Is that something you can work with? *********** Regards, Ron XL2002, WinXP "FARAZ QURESHI" wrote: Is there any way to find out the column number within an array that matches with the lookup value like the "Match" Function? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula that uses Last Number in Column of another worksheet | Excel Discussion (Misc queries) | |||
| Always use the last number in another column for a formula | Excel Discussion (Misc queries) | |||
| Formula to Identify Column Number | Excel Discussion (Misc queries) | |||
| Write formula to add "1" to each number in a column | Excel Worksheet Functions | |||
| I need a formula that will sum the top 3 number in a column | Excel Worksheet Functions | |||
Linear Mode
