Leave cell blank
You're welcome!
Biff
"Steved" wrote in message
...
Thankyou.
"T. Valko" wrote:
Try this:
=IF(ISNUMBER(MATCH($E4,FaultyBuses!$A$2:$A$1997,0) ),VLOOKUP($E4,FaultyBuses!$A$2:$B$1997,2,0),"")
Biff
"Steved" wrote in message
...
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.
|