Best Lens for Up Close Shots?

What CANON and NIKON lens would be the best for taking pictures of people, flowers, walls, cars…

for under 200 american dollars

There are none for that price.

The least expensive Macro lenses:

Nikon 40 mm f/2.8, $280
Canon 50 mm f/2.5, $300

Macro lens will do you…

if you are being cheap, look at Tamron, Tokina and Sigma… They tend to be cheaper…