Forum Discussion
Index match with multiple sheets
How do I use index match formula to pull a similar type of data from different sheets.Example I would like to pull different dam storage data from different sheet for a particular year and month.
12 Replies
It very depends on how your data is structured, could you provide small sample file to illustrate?
I attached here is example of what I am trying to do.Basically I want to pull the data to my master so that I can create a dynamic chart.
I'd transform other sheets data to tables (DamA, DamB, etc), it'll be more flexible. With that
Years: =TRANSPOSE(INDIRECT($F$3 & "[Year]")) Data: =TRANSPOSE(INDIRECT($F$3 & "[" & $B7 & "]" ))like
