Dear All,
I am trying to enter employees bank loan interest recover detailes in excel sheet ("3-2 Reimbursment" Sheet). For this purpose i use two sheets, one "3-2 Reimbursment" , other "Loan Details". in Account Details sheet, there are many emloyees details and some amployees may have more Loan numbers. (My Excel version is 2016)
While this purpose, have issues,
01). I tried to get multiple loan numbers belongs to the emploee (PF No.) in to dropdown list using vlookup function or any other methord (in to "3-2 Reimbursment" Sheet colum "D" in to dropdown list) How to do this? Eg. In A4 Employee number, i try to get loan numbers belogs that number in to D4 cell as dropdown list.
Thanks,
Priyantha.
I am trying to enter employees bank loan interest recover detailes in excel sheet ("3-2 Reimbursment" Sheet). For this purpose i use two sheets, one "3-2 Reimbursment" , other "Loan Details". in Account Details sheet, there are many emloyees details and some amployees may have more Loan numbers. (My Excel version is 2016)
While this purpose, have issues,
01). I tried to get multiple loan numbers belongs to the emploee (PF No.) in to dropdown list using vlookup function or any other methord (in to "3-2 Reimbursment" Sheet colum "D" in to dropdown list) How to do this? Eg. In A4 Employee number, i try to get loan numbers belogs that number in to D4 cell as dropdown list.
Thanks,
Priyantha.
