I could not get the robot to enter the different vendor codes from excel or even by choosing one specific vendor. Did not work when I tried your solution file either.
What exactly happens? Do you get an error?
No error, just that the robot do not fetch the vendor code names from the Excel.
by default the for each activity will stop on empty rows. maybe this is the case. click on the for each activity and go to properties tab on the right and select “process” behavior on empty rows. lets see what happens next. let me know.
Thanks you for the reply. I do not think that is the case since there is no empty rows in the excel. But no worries, I will not work anymore on this training session, I have moved on 
ashokkarale
MD_Farhan1
Ajay_Mishra
postwick
Dheerendra_vishwakarma
Anil_G
chandreshsinh.jadeja
Gautham_Pattabiraman
vrdabberu
aravindbalineni123