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.

=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" wrote in message
...
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.