Sheet vs. Excel validation functions?

Does sheet support Validation, VLOOKUP, Lists, etc like in Excel?

I imported an Excel spreadsheet and lost all of my validation formulas, please advise, thanks!