Will a game that requires Windows Vista work in Windows XP

No. A few games from Microsoft, such as Halo 2, were modified to work on Windows XP because they did not actually use any Vista-specific features. In general, though, a game that says it requires Vista likely does, or at least will not work on XP without modification.