Hopefully an Easy Fix: Working formula not working when applied to other worksheets

Hi,

I have developed a formula that works when all the data is on the same worksheet. However, when I create a separate worksheet for the source data and attempt to draw it from there the formula no longer works. I am selecting the correct values from the new source worksheet and integrating it into my original working formula. This is the original working formula and thepart of the formula that is causing trouble--I believe the INDIRECT function is the culprit.

OFFSET(INDIRECT(VLOOKUP(E25,$BP$16:$BQ$16,2,FALSE)),MATCH(F25,$BJ$18:$BJ$26,0)-1,MATCH($F$49,$BK$15:$BN$15)-1)

Every input save for $F$49,F25,E25 will now be found on the new source worksheet. However, if absolutely needed I can bring these guys over as well.

Thanks for your help.

What do you mean by "formula not working"? Is the formula returning some odd numbers, or do you get an error, or what?

The formula is returning zero despite which variable is selected from the drop down list found in F25. Despite what I select the results are the same Choose A = 0, B = 0, etc. Whereas before it was select A = 75%, B = 0.23% etc.