... i live in Bangladesh. Compared to the earnings, camera equipment are quite expensive here. therefore, i have to make every cent count. Currently I use Nikon D3300 and 35mm f1.8. and only use my cameras for travel, and family photos. I don't intend to ever work as a professional photographer.
Currently i am looking for a 2nd lens. for financial restriction, i am unable to buy one lens for portrait, and one lens for Macro. Therefore i'm looking for a lens that can do both. money is an issue, so the cheaper the better.
please advise as to which lens will be ideal for my need.
First a few points:
Macro lenses tend to be quite expensive. They tend to cost more than your current camera and lens together. In the current catalogue, the only Nikon macro lens that costs less is the AF-S DX Micro-Nikkor 40mm f/2.8G. Since that lens is so close in focal length to your current lens, there wouldn't be much point in getting it for portrait work.
Macro lenses tend to be very sharp, but slow to autofocus. These are not necessarily the best attributes for a portrait lens. You should be aware that this is part of the compromise you will be making to save money.
There is no one ideal focal length for taking portraits. You can take portraits with your 35mm lens. On DX cameras like your D3300, I use focal lengths between about 18mm and 200mm to take portraits. The reason for the wide range of focal lengths is that not all portraits are framed the same. The focal length required depends on the distance from camera to subject, the orientation of the camera (long side of frame horizontal or vertical - called respectively landscape and portrait orientation), the aspect ratio of the final image (ratio of width to height) and the amount of the subject I want in the frame. For instance I would use 200mm for a tight head shot taken from about 3m distance (Just the head filling the frame in portrait orientation cropped for an 8" x 10" print). I might use 18mm for a group portrait of a cricket team standing/kneeling in two or three rows.
When taking portraits that are intended to be flattering of adult subjects, best results are usually obtained if the distance to the subject is over 2.5m. I tend to use 3m as a starting point and adjust forward or backward depending on the shape of the subject's face and its angle to the camera. Flatter faces or faces not perpendicular to the camera get a shorter distance than faces that are narrow or have prominent features directly facing the camera. A typical human head is about 30cm tall. For a head and shoulders shot from 3m in which the head was 1/2 the height of that same 8x10 frame, I'd use a 105mm lens on DX. For a head & shoulders shot in landscape orientation with the head again being 1/2 height of the frame, I'd use 85mm. Looser framings or shorter subject distances need a shorter focal length. In portrait orientation from 3m on DX, 85mm frames an area of about 55cm x 85cm (uncropped).
Some people like really shallow Depth of Field in their portraits, and think they need a very fast lens to achieve this. However, with the focal lengths and subject distances I use, I often find myself stopping down to f/4 or even as much as f/8 to get sufficient DoF to keep enough of the subject sharp. It's only when you use shorter focal lengths at portrait distances that you need a fast lens to get a shallow DoF. Macro lenses are usually stopped down quite a bit to get adequate DoF for small subjects. So you do not necessarily need a fast lens for your purposes.
With that and your budget limitations in mind, the most obvious macro lens for your purposes in Nikon's current catalogue is the AF-S DX Micro Nikkor 85mm f/3.5G ED VR. Two other possibilities are the AF-S Micro Nikkor 60mm f/2.8G ED, and the AF-S VR Micro-Nikkor 105mm f/2.8G IF-ED.
