A VIN is 17 characters. The first three, the world manufacturer identifier, say who built the car. WBA is BMW. WAU is Audi. WVW is Volkswagen. WDD is Mercedes-Benz. That is enough to narrow the shelf, not enough to pick the bottle.
The same model can leave the factory with a petrol, a diesel, or a hybrid, and those engines often call for different approvals. After the VIN identifies the maker, check the model year and the engine, or read the spec printed on the filler cap.
OilClub.eu opens the list from the make you choose, then shows oils whose published approvals include that maker. A VIN can tell you the maker, but it does not replace the handbook for a specific engine code.