While a normal lens (reversed for best performance) can be used for macro work, the best results are obtained with a flat-field close-focus lens, such as an enlarging, process, or macro lens. These three different names reflect their intended use, but are essentially the same type of lens.
“Best results” in this case means better center-to-corner focus agreement due to flatter field. Close-focusing flat-field lenses also produce greater resolution of fine detail than a standard type camera lens used in macro work.
I’ve gotten excellent results in using various enlarging lenses with my Nikon SLRS with a Nikon bellows unit. The lenses were used reversed. That was necessary due to the connecting hardware I have. The connecting hardware items I used are: Nikon BR-2A Lens Reversing Ring and various step-up rings (40.5 mm to 52 mm for my EL Nikkors from 50 mm to 105 mm, and 43 mm to 52 mm for use with my 80 mm Rodagon enlarging lens).
https://www.bhphotovideo.com/c/product/37171-REG/Nikon_2657_BR_2A_Lens_Reversing_Ring.html
A less-expensive version.
https://www.bhphotovideo.com/c/prod...mount_52mm_nikf_52mm_filter_thread_macro.html
Step-up rings.
https://www.bhphotovideo.com/c/product/809750-REG/Sensei_sur40_552_40_5_52mm_Step_Up_Ring.html
https://www.bhphotovideo.com/c/product/809758-REG/Sensei_sur4352_43_52mm_Step_Up_Ring.html
I have used the Sensei step-up rings. They’re well made.
The fully-closed length of the bellows unit will limit the magnification range with a 50 mm lens. So, for photographing a medium format film you will likely have to use a lens of 80 mm or longer, depending upon the particular format.