Forum Discussion
Indirect vlookup match
I have two sheets for 2 assets: 13100 and 13200. I have monthly numbers (i.e. Jan, Feb etc) for several accounts. I am trying to create a formula to get the numbers for a particular month for a parti...
please check following formula
=VLOOKUP($A5,INDIRECT( $B5&"!Data"), MATCH(C$2, INDEX( INDIRECT( $B5&"!Data"),1,),0 ), 0)
The index formula extracts only first row from Data for MATCH formula.
Let me know how it works !!
Many thanksKodipady
It is working perfectly.