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.