Vlookup & IF Function - What's wrong?

[Olsonsbiz]

What looks wrong here?

=if(isna(VLOOKUP(B11, table!$A$2:$B$10,2,TRUE)," ",VLOOKUP(B11, table!$A$2:$B$10,2,TRUE))

Something's not right here as when I type it this way - it tells me there are errors with it and then highlights the quotation marks.

Side note: I'm attempting to return a blank cell instead of #N/A. The B11 column will have data entered as needed - but I want to copy the formula on down without the #N/A coming up.

Os

[duane]

) are wrong!

try this

=if(isna(VLOOKUP(B11, table!$A$2:$B$10,2,TRUE))," ",VLOOKUP(B11, table!$A$2:$B$10,2,TRUE))

note this leaves a space if the isna is true - is this what you want?

[Olsonsbiz]

YES!!! :D

Perfect - it works perfect!

Thank you SO much Duane!

Os