Index/Match formula

[Steve N.]

Good evening -

I need help with an Index/Match formula for a range (multiple columns) based on the column header. I've worked up a mess with the formulas I've attempted and the best I've been able to do is build one that gets data across a row rather than down the column...

Advice? Solutions? Any good tutorials out there for the thick-headed?

Oh, and is the second date column necessary - can this be done using only the one date column in the range?

Thank you...

Steve

[Ace_XL]

the 2nd column of dates is redundant if its the same as Column A

Use

=INDEX($B$2:$H$20,MATCH($A2,$A$2:$A$20,0), MATCH($M$1,$B$1:$H$1,0))

Copy down

[Steve N.]

Most excellent Ace - Thank you!

I see I had the match functions reversed and of course the redundant date column.

Can you tell me why the match functions need to be in that particular order? I find myself needing these index/match formulas more and more often but I'm still confused by much of the syntax.

[Ace_XL]

The syntax for INDEX is INDEX(array,row_num,column_num)

So in your formula you first need to match the row i.e. the dates and then the column i.e. the dropdown in M1

[FDibbins]

Just to add to Ace's notes, if you use the formula editor (fx), it will guide you through the construction and syntax of a formula