Concatenate in a formula

I've done this before, but for some reason I cant get this to work on this
formula:

=IF(ISERROR(VLOOKUP(ROW()-1,Formulas!$D$2:$BK$2500,51,FALSE))=TRUE,"",VLOOKUP(ROW()-1,Formulas!$D$2:$BK$2500,51,FALSE))

I would like to replace the D in "Formulas!$D$2" to read from cell k2 and I
would like the number 51 to read from cell k3.

If someone could help me with this, I would really appreciate it.

=IF(ISERROR(VLOOKUP(ROW()-1,INDIRECT("Formulas!$"&K2&"$2:$BK$2500"),INDIRECT
(K3),FALSE))=TRUE,"",VLOOKUP(ROW()-1,INDIRECT("Formulas!$"&K2&"$2:$BK$2500")
,INDIRECT(K3),FALSE))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jordan" <[email protected]> wrote in message
news:[email protected]...
> I've done this before, but for some reason I cant get this to work on this
> formula:
>
>
=IF(ISERROR(VLOOKUP(ROW()-1,Formulas!$D$2:$BK$2500,51,FALSE))=TRUE,"",VLOOKU
P(ROW()-1,Formulas!$D$2:$BK$2500,51,FALSE))
>
> I would like to replace the D in "Formulas!$D$2" to read from cell k2 and
I
> would like the number 51 to read from cell k3.
>
> If someone could help me with this, I would really appreciate it.