Problem with vlookup and #n/a function

[goldenvision]

I have referenced another post on here to find out how to not display #n/a when vlookup fails to find a value.

I have applied the solution and the formula seems to be disregarding the vlookup statement.

My formula is
=IF(ISERROR(VLOOKUP(A2,'Backup Failures.xls'!Nov14,2,FALSE)),"",VLOOKUP(A2,'Backup Failures.xls'!Nov14,2,FALSE))

Any pointers would be very helpful.

 

[Peter_SSs]

goldenvision

Is Nov14 a sheet name? Try something like:

=IF(ISERROR(VLOOKUP(A2,'[Backup Failures.xls]Nov14'!Lookup range here,2,FALSE)),"",VLOOKUP(A2,'[Backup Failures.xls]Nov14'!Lookup range here,2,FALSE))

 

[goldenvision]

Peter,

Nov14 is a named range.

I have applied the following formula and it seems to do the trick
=IF(ISNA(VLOOKUP(A27,'Backup Failures.xls'!Nov14,2,FALSE)),"","x")

It's not as complicated as the previous formula but it does only return static values from the result of the IF statement. I would guess that I can substitute the IF statement results with VLOOKUPs if necessary.

Thanks for you assistance