Vlookup

[Redlittle]

I have the following VLOOKUP =VLOOKUP(C3,'Client Database'!D3:H198,5,FALSE)

How can I change this so that if there is no information in column 5 rather than returning a "0" I would prefer it to return "N/A"

Thanks in advance

[Pepe Le Mokko]

Do you mean the result is 0 or an empty cell although C3 is found in col D?

[63falcondude]

Try this:

=VLOOKUP(C3,'Client Database'!D3:H198,5,FALSE)&""

To return a blank if the cell in column H is empty.

Having it return N/A could be a little misleading since VLOOKUP will return #N/A if C3 isn't found in column D.

If you insist on it returning N/A, you can use this:

=IF(VLOOKUP(C3,'Client Database'!D3:H198,5,FALSE)="","N/A",VLOOKUP(C3,'Client Database'!D3:H198,5,FALSE))