Sometimes, it's better to copy from the formula bar and paste into the message.

Are you sure you included enough rows?

If there's nothing below your table, maybe:

=IF(ISERROR(VLOOKUP($A3,'Feb Loan 06'!$A:$D,4,FALSE)),0,
VLOOKuP($A3,'Feb Loan 06'!$A:$D,4,FALSE))

And if $a3 contains only digits, maybe the numbers are text in one location and
really numbers in the other (or maybe you have leading/trailing/embedded
spaces)) or maybe it's just a typo.

Debra Dalgleish has some troubleshooting tips at:
http://contextures.com/xlFunctions02.html#Trouble

malycom wrote:

Hi

Can anyone help with this problem.

I am using a VLOOKUP to pull information from a worksheet called "Feb Loan
06" This is the exact formula as used in my worksheet:
=IF(ISERROR(VLOOKUP($A3,'Feb Loan
06'!$A$2:$D$473,4,FALSE)),0,VLOOKIP($A3,'Feb Loan 06'!$A$2:$D$473,4,FALSE))

I use this formula very regularly but this is the first time the formula
does not pull in the correct data.

The data it is pulling in should show either the value 0.00 or any other
number. There are other numbers larger that 0.00 in the column I am pulling
from, but for some reason, the only figure getting pulled through is 0.00,
even if the client should have a figure of 3000.00 for example.

Any ideas as to what I may be doing wrong.

Thanks in advance

--

Dave Peterson