vlookup code not working right

[Guest]

I have 4 workbooks tied together with links. For one column of the Paycheck Calculator I have a VLOOKUP to match the date in that row to the date in the Payroll Master workbook. Here's the formula
=IF(VLOOKUP($A63,'[Payroll_Master_Redding_2004.XLS]MAR 04'!$A$8:$Y$40,22,TRUE)<>0,VLOOKUP($A63,'[Payroll_Master_Redding_2004.XLS]MAR 04'!$A$8:$Y$40,22,TRUE),""
The reason for the IF...<>0... is so that if there isn't anything there it stays blank. That value can be either + or -, thus the <>0.
Works fine when I created it with Excel XP, but when I sent it to Excel 2000, it quits working, if it's a positive value or not
If there's a better way, let me know. I just need - if this cell is blank, leave blank, otherwise return the value. BTW the ISBLANK won't work because the cell it's looking for has a formula in it...

 

[RagDyer]

This should work, plus it eliminates a double Vlookup, which tends to strain
XL when used in large WBs.

=IF(ISNA(MATCH($A63,'[Payroll_Master_Redding_2004.XLS]MAR
04'!$A$8:$A$40,0)),"",VLOOKUP($A63,'[Payroll_Master_Redding_2004.XLS]MAR
04'!$A$8:$Y$40,22,TRUE))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I have 4 workbooks tied together with links. For one column of the Paycheck
Calculator I have a VLOOKUP to match the date in that row to the date in the
Payroll Master workbook. Here's the formula:
=IF(VLOOKUP($A63,'[Payroll_Master_Redding_2004.XLS]MAR
04'!$A$8:$Y$40,22,TRUE)<>0,VLOOKUP($A63,'[Payroll_Master_Redding_2004.XLS]MA
R 04'!$A$8:$Y$40,22,TRUE),"")
The reason for the IF...<>0... is so that if there isn't anything there it
stays blank. That value can be either + or -, thus the <>0.
Works fine when I created it with Excel XP, but when I sent it to Excel
2000, it quits working, if it's a positive value or not.
If there's a better way, let me know. I just need - if this cell is blank,
leave blank, otherwise return the value. BTW the ISBLANK won't work because
the cell it's looking for has a formula in it...