Nikon makes 2 superb macro lenses: a 60 mm and a 105. You have to get right on the subject with the 60, so the 105 is better for getting some working distance like critters in a fish tank.
The three major third party manufacturers make fine macro lenses for about half the price, sigma, tamron and Tokina. Also, you can buy lenses used for a substantial discount. I once bought a Nikon telecom renter in ugly condition. It looks beaten up, but it works like new. For 25 percent of new, it was a great buy.
Now, your camera does not have a focus motor. So if you want autofocus, you need to get an AFS lens or it's equivalent. Many people only use manual focus for macro.