Excel vlookup question 1

[finbib]

I have a named range in an Excel sheet called Commissions. I'm using the following formula to look for company names in Commissions in order to determine which invoices should have commissions paid on them.

=IF(C3=(VLOOKUP(C3,Commissions,1,FALSE)),"Y","&quot

The formula works, except for the else part of the statement, which should result in a null value being placed in the cell. What is actually happening is the formula is returning a "#N/A" in the cell, since that would mean the company name isn't in the list at all.

Is there a way to show the results as blank, rather than #N/A? I'm using this cell as a link for some other cells on different sheets and it is screwing them up as well.

TIA,

Bob Osborne

 

[bluedragon2]

=IF(ISNA(VLOOKUP(C3,Commissions,1,FALSE)),"","Y&quot



Blue

If I wasn't Blue, I would just be a Dragon...

 

[finbib]

Blue,

Thanks, that fixed it perfectly.

Bob