| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find values across a row and return a text value from the same column
On Tue, 19 Mar 2013 17:50:30 -0700 (PDT), zvkmpw wrote:
=INDEX($A$1:$J$1,1,MATCH(LARGE($A2:$J2,COLUMN()-10),$A2:$J2,0)) Not tested but I think you would get the same result, and not have it be dependent on the intial column, by using: COLUMNS($A:A) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return text if column and row match values | Excel Worksheet Functions | |||
| Find values in table and return row/column name | Excel Worksheet Functions | |||
| Find max value from 3 cells, return text, but 2 max values same! | New Users to Excel | |||
| find a value down a column and return seventeen values in the row | Excel Programming | |||
| Find certain text in a column and return statement | Excel Worksheet Functions | |||
![Ron Rosenfeld[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
