Problem with vlookup and #n/a function

goldenvision

Board Regular
Joined
Jan 13, 2004
Messages
234
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

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
41,750
Office Version
365
Platform
Windows
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

Board Regular
Joined
Jan 13, 2004
Messages
234
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
 

Forum statistics

Threads
1,077,926
Messages
5,337,242
Members
399,134
Latest member
ChetManley

Some videos you may like

This Week's Hot Topics

Top