Leave cell blank

S

Steved

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.
 
T

Teethless mama

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

Ragdyer

Try this:

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

T. Valko

Try this:

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

Biff
 
Top