Index / Match

[thorpyuk]

Hiya,

My INDEX formula isn't working.... i cant seem to isolate the column correctly...

=INDEX(Despatches_Weekly_Total_Countries,ROW()-7,MATCH(F3,INDEX(Despatches_Weekly_Total_Countries,1),0))


It's picking up the row no problem.

Despatches_Weekly_Total_Countries is my array (27 rows, 57 columns)

I need to match Cell F3 to a value on the first row...

Arg, does MATCH work on non-numeric values? :S

 

[Andrew Poulsom]

To return a reference to the first row:

INDEX(Despatches_Weekly_Total_Countries,1,0)

 

[T. Valko]

Hiya,

My INDEX formula isn't working.... i cant seem to isolate the column correctly...

=INDEX(Despatches_Weekly_Total_Countries,ROW()-7,MATCH(F3,INDEX(Despatches_Weekly_Total_Countries,1),0))


It's picking up the row no problem.

Despatches_Weekly_Total_Countries is my array (27 rows, 57 columns)

I need to match Cell F3 to a value on the first row...

Arg, does MATCH work on non-numeric values? :S

Try including the column argument to the inner INDEX function but set it to 0 like this:

INDEX(Despatches_Weekly_Total_Countries,1,0)

0 means "all columns"

 

[thorpyuk]

Thanks guys, thats great!