I have not tested this but try this;
replace : with & ":" & in your formula

"Matt" wrote:

I am trying to use the following formula:

=MATCH(G1,INDIRECT("'Sheet3'!"&"D"&MATCH(B4,Sheet3 !$A$2:$A
$21647,0)):INDIRECT("D"&MATCH(B4,Sheet3!$A$2:$A$21 647,1)),-1)

but keep getting the #VALUE!. When I do the formula auditing, it
works until he

=MATCH(125,Sheet3!$D$21323:$D$21645,-1)
then:
=MATCH(125,#VALUE,-1)

Am I doing something wrong?

Thanks for any help!