indexing - Excel INDEX, MATCH and INDIRECT function combination gives #VALUE! error -

i trying pull data workbook sheet(sheet's name - data). using indirect , concatenate functions define range in values indexed , searched. gives me #value! error.

in sheet's "miscdata" b7 cell define range (for example 12000).

my formula:

=index(((data!d$3:indirect(concatenate("d"&miscdata!$b$7 )))),match(j2,if(data!b:b=i2,data!c:c,0),0)) 

if defining range manually (without indirect , concatenate functions, formula working perfectly. tired enter formula ctrl+shift+enter, gives me same #value! error.

sorry, cannot paste here screenshot, here's link:

thank's in advance.

in case, using concatenate function incorrectly.

to combine 2 pieces of text, can either say:

=a1&b1 

or can write concatenate function, so:

=concatenate(a1,b1) 

note use function, type "," instead of &.