Remove #N/A error

=IF(D8="L",VLOOKUP(H8,Table!$C$3:$D$7,2),IF(D8="P",VLOOKUP(H8,Table!F3:G7,2),""))


I've tried using ISNA to remove #N/A error when H8 is 0 or no value.

Unfortunately, whenever I do so, I'm getting 'too many argument' error.

It is not clear enough , need to look data in h8
try this
=iferror(IF(D8="L",VLOOKUP(H8,Table!$C$3:$D$7,2),IF(D8="P",VLOOKUP(H8,Table!F3:G7,2),"")),"")
Punnam

Hi kenjcd ,

upload a sample workbook with out any confidential data , make sure you have enough data to explain your difficulty.

Punnam

Hi, Punnam.

I think your formula works just fine. So far, it's working.
Thanks ya

@ martindwilson - i'm using Excel 2007 ^-^

Hi kenjcd ,

1) This is show "" , in case of any error caused by the function .
2) I suggest you to change the version of Excel from excel 2003 to Excel 2007 , in your profile page
3) If your question answered mark the thread as solved & rate one who helped you "Add Reputation".
Punnam