I have the formula below to lookup a supplier address from another sheet once the supplier name is entered into the B8.
The formula works great but when there is an empty cell on the 'Supplier Details' sheet it return 0.
What would I need to add to this formula to return a blank?
Kieran

=LOOKUP($B$8,'Supplier Details'!$A$4:$A$100,'Supplier Details'!$B$4:$B$100)