Changing #N/A error into Text

N

Newbie15

I am doing a VLOOKUP to compare a listing of numbers from 2 seperate years
for respective client names... it looks like this.... =VLOOKUP(A4,'2005
information'!$A$4:$L$97,12,FALSE). Now some of the clients that are in 2005
are not in 2004, so this returns a #N/A error, because there is no number to
look for. Now I want to change #N/A to text like "No respective client" to
give more information and look better than just #N/A, is there a way to do
this, because I have been looking at every formula, and Only found the
Error.Type formula, but this is a circle reference, and it still just returns
#N/A..... =VLOOKUP(A13,'2004
Information'!$A$4:$L$81,12,FALSE)=IF(ERROR.TYPE(C13)=7,"No Respective
Client") This is the circle refernece that returns N/A still.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to change and error message to text 4
Same forumula returns both 0 & N/A 2
Multiple VLOOKUP in an IF statement 2
Lookup functions always return n/a ??? 3
error handling-need to get rid of a value returned as #N/A 2
Conditional sum, when condition has multiple values 3
#N/A Error Reference 2
N/A Error with VLOOKUP Formula - Excel 2007 6

Top