"systemx" wrote:
> =IF(ISERROR(VLOOKUP($B2,Distribution!$B$12:$B$150,1,FALSE)),
> "MY TEXT STRING",(VLOOKUP($B2,Distribution!$B$12:$B$150,1,FALSE)))

Perhaps this shorter version using MATCH would also suffice:
=IF(ISNA(MATCH($B2,Distribution!$B$12:$B$150,0)),"MY TEXT
STRING",$B2)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---