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...
This formula in C5 should work for you:
=VLOOKUP($A5,
INDIRECT($B5&"!Data"),
MATCH(C$2,INDIRECT($B5&"!$A$4:$H$4"),0),0)
Thanks a lot. This is also working. Twifoo