Try it like this:
=IF(VLOOKUP(...)=0,"",VLOOKUP(...))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"bollard" wrote:
We have a sheet which contains a VLOOKUP. But when the date looked up on
another sheet finds a blank, the date returned onto the sheet with the
VLOOKUP command, comes up with the date: 00/01/1900. We'd like it just to
show a blank field.
This is the current formula: =VLOOKUP(A3,Offers!$B$2:$U$751,18,FALSE)
Thanks.