Lookup Index #NA Help!!!

[stephen.smith]

Hi Guys
I am having issues with two formulas which I have pasted below. Both of the formulas work perfectly however in some cases there is will be no possible answer in which case the cells with these formulas display #NA. Is it possible to perform these formulas in a way that if there is no possible answer that the cell remains empty and does not display #NA.
Thanks in advance and if anyone needs more info please let me know.

=VLOOKUP(B3,'PS 1'!$VW$1:$VX$13,2)
=INDEX('PS 1'!$B$52:$G$52,,MATCH(2,'PS 1'!$B$5:$G$5,0))

 

[VoG]

Try like this

=IF(ISNA(VLOOKUP(B3,'PS 1'!$VW$1:$VX$13,2),"",VLOOKUP(B3,'PS 1'!$VW$1:$VX$13,2))

 

[BillXL]

If you are using Excel 2007, you can use IFERROR:

=IFERROR(VLOOKUP(B3,'PS 1'!$VW$1:$VX$13,2),"")

This will give you a balnk cell if the lookup formula is #NA.

If you are using 2003, you can achieve the same reult by using ISNA. Let me know if this is the case & I will show you what to do.

Bill

 

[stephen.smith]

Hi Peter thanks but this doesnt work, an error message appears stating that I have too many arguments. Any ideas what is going wrong?

 

[VoG]

Missing a ) I think

=IF(ISNA(VLOOKUP(B3,'PS 1'!$VW$1:$VX$13,2)),"",VLOOKUP(B3,'PS 1'!$VW$1:$VX$13,2))