Hi,

Assuming the obvious has been checked; i.e the data is actually in the
search table and the references and returns column number are valid.

Check the formatting of the search object and the cells being searched. I
would expect the prime cause to be that you are looking for a number in a
text field or vice versa. You are getting zeros because your error trap is
correcting either ISNA# or VALUE# errors to 0.
If your search area is a data dump also watch for trailing or leading spaces
convert what looks like a number to text.

The fact that the formula has been OK before hints to me that the data
format has changed.

hth

Giz

"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