Concatenate in a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top