I have never yet found anything that gets foundation out of clothing (thanks to girls getting it on to school blouses), nor mascara out of carpet, so will be interested to see if anyone else has managed it.
This is my dh's mixture for removing red wine from the carpet. It really works.
You mix vanish powder and washing up liquid an warm water to make a paste. Put it on the stain only. Leave it for a bit, maybe 20 minutes but keep an eye on it as it is quite powerful! Remove it with water and a damp cloth.
I don't know if it works on foundation but my dh got this off the internet one night after he spilt some red wine on the carpet when I was in bed. It worked so well that te next day he chucked some more wine on the carpet to show me.