| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Index and Match
The data looks like this
songs, totals, last used, prior to 2013, 1/5/2013, 1/12/2013, title1, =SUM(E2:BD2), =INDEX($1:$1,MATCH(1,2:2)), 1, 1, , , , 1, .... title2, =SUM(E3:BD3), =INDEX($1:$1,MATCH(1,3:3)), 1, , , ,1, , , .... etc When I tried this, the INDEX() formula prompted a "circular reference" warning from Excel. This might have something to do with the problem. Maybe this would work better: =INDEX($D$1:$BD$1,MATCH(1,D3:BD3)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| INDEX MATCH Functions in LibreCalc (Excel) - Non unique valuesreturn wrong index result | Excel Worksheet Functions | |||
| Find Exact Match using INDEX, MATCH | Excel Worksheet Functions | |||
| index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions | |||
Threaded Mode
