thank you all for your answers i had spent a couple of days playing with this. +rep for all who replied.
i went with outofthehat =(IF(ISBLANK(Sheet1!B2),VLOOKUP(Sheet2!A2,Sheet3!A:B,2,FALSE),Sheet3!B2)
cheers all thank you.