Is Error and Vlookup

**VegasL** · 09-16-2009, 03:16 PM

How do I re write this formula to incorporate iserror function to show "" when a value of false or N/A is found.

=IF(K8<>"",VLOOKUP(F8,'My Sheet'!$F$2:$I$489,4,FALSE))

Thanks

**NBVC** · 09-16-2009, 03:26 PM

Try

=IF(K8<>"",IF(Isna(VLOOKUP(F8,'My Sheet'!$F$2:$I$489,4,FALSE)),"",VLOOKUP(F8,'My Sheet'!$F$2:$I$489,4,FALSE))

**ChemistB** · 09-16-2009, 03:30 PM

Does this work for you?

Please Login or Register  to view this content.

**VegasL** · 09-16-2009, 03:42 PM

the first code worked except it returned false also, the 2nd got an error message.

first code will get the job done.

thanks to both of you - appreciate you're help

**NBVC** · 09-16-2009, 03:48 PM

Try:

=IF(K8<>"",IF(Isna(VLOOKUP(F8,'My Sheet'!$F$2:$I$489,4,FALSE)),"",VLOOKUP(F8,'My Sheet'!$F$2:$I$489,4,FALSE),"")

**VegasL** · 09-16-2009, 04:39 PM

Hi NBVC,

Getting...you've entered too many arguments for this funciton.

okay, it seems like
=IF(K8<>"",IF(Isna(VLOOKUP(F8,'My Sheet'!$F$2:$I$489,4,FALSE)),"",VLOOKUP(F8,'My Sheet'!$F$2:$I$489,4,FALSE),""))) works but still returning false. Basically i want a blank cell when error or false found.

**NBVC** · 09-16-2009, 04:45 PM

Forgot a closing parenthesis:

=IF(K8<>"",IF(ISNA(VLOOKUP(F8,'My Sheet'!$F$2:$I$489,4,FALSE)),"",VLOOKUP(F8,'My Sheet'!$F$2:$I$489,4,FALSE)),"")

**VegasL** · 09-16-2009, 04:55 PM

Wow, You Da Man!. Thanks Bud!

**philster1** · 11-10-2009, 05:59 AM

Hi
Sorry to add to this thread.

What is the VBA equivalent for a macro?

I've got below but not able to get it to work.

Sub Replace()
Sheet2.Activate
Range("E2:E8") = "=VLOOKUP(A2,$A$2:$B$5,2,FALSE)"
IF(ISERROR(VLOOKUP(A2,$A$2:$B$5,2,FALSE)),"",VLOOKUP(A2,$A$2:$B$5,2,FALSE))
End Sub

basically, what im trying to do is, populate a column from a table for a particular range. If the range has missing data, 'NA' will show and therefore needs to be coverted to blank cells.

How do i convert 'N/A' it to a blank cell?

thanks
Phil

**DonkeyOte** · 11-10-2009, 06:37 AM

philster1, welcome to the board, however, please note:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.