Auto Type Text Box and Returning Values

[grcshekar]

Hi Experts over there !

The file in link Sample File
1. In Sheet Portfolio, in Column A, I need scheme names in auto fill text box from Column D in sheet NAV
2. Once text is selected from auto fill text box, respect value Column E of sheet NAV should appear in Column C of sheet Portfolio and value in column F of sheet NAV should appear in Column B of sheet Portfolio

Request assistance please

 

[fadee2]

Cannot download the file.
"The file is in owner's trash"...

 

[grcshekar]

MF_Tracker_GRCShekar_2021.xlsm

drive.google.com