Leave cell blank

[Guest]

Hello from Steved

=IF(ISNUMBER(MATCH($E4,FaultyBuses!$A$2:$A$1997,0)),VLOOKUP($E4,FaultyBuses!$A$2:$B$1997,2,0))

Please how do I get the above formula to leave the cell blank, as at the
moment it returns FALSe

Thankyou.

 

[Guest]

=IF(ISNUMBER(MATCH($E4,FaultyBuses!$A$2:$A$1997,0)),VLOOKUP($E4,FaultyBuses!$A$2:$B$1997,2,0),"")

 

[Ragdyer]

Try this:

=IF(ISNUMBER(MATCH($E4,FaultyBuses!$A$2:$A$1997,0)),VLOOKUP($E4,FaultyBuses!
$A$2:$B$1997,2,0),"")

 

[T. Valko]

Try this:

=IF(ISNUMBER(MATCH($E4,FaultyBuses!$A$2:$A$1997,0)),VLOOKUP($E4,FaultyBuses!$A$2:$B$1997,2,0),"")

Biff

 

[Guest]

I thankyou all.

Try this:

=IF(ISNUMBER(MATCH($E4,FaultyBuses!$A$2:$A$1997,0)),VLOOKUP($E4,FaultyBuses!
$A$2:$B$1997,2,0),"")

 

[RagDyeR]

And we all appreciate the feed-back.

 

[Guest]

Thankyou.

Try this:

=IF(ISNUMBER(MATCH($E4,FaultyBuses!$A$2:$A$1997,0)),VLOOKUP($E4,FaultyBuses!$A$2:$B$1997,2,0),"")

Biff

 

[T. Valko]

You're welcome!

Biff

Thankyou.