Alterting Formula to remove Blanks

[Excel_77]

Hi All,

I have the following formula which looks for specific values in cells and if they are found a value is returned and if there is no matching value the cell is left empty, I want to change the empty cells to "n/a" is this possible? So basically all I want to do is put something in at the end so that if an empty cell is returned it's converted to a "n/a".

=IFERROR(LEFT(VLOOKUP(AK2,Source!D:D,1,FALSE),LEN(VLOOKUP(AK2,Source!D:D,1,FALSE))-5),"")&IFERROR(LEFT(VLOOKUP(AL2,Source!D:D,1,FALSE),LEN(VLOOKUP(AL2,Source!D:D,1,FALSE))-5),"")&IFERROR(LEFT(VLOOKUP(AK2,Source!D:D,1,FALSE),LEN(VLOOKUP(AK2,Source!D:D,1,FALSE))-5),"")&IFERROR(LEFT(VLOOKUP(AM2,Source!D:D,1,FALSE),LEN(VLOOKUP(AM2,Source!D:D,1,FALSE))-5),"")

 

[Scott Huish]

I'm not quite sure what formula is supposed to do and can probably be written a lot more concise, but just put n/a in the quotes instead of just ""