Auto fill out exact matching data for multiple entries from another sheet

Hi,

This is Ryan. I have a sheet that my junior staffs mistakes so much for wrong data input. I have decided to put it in this way that when ever I will write the data in one sheet, exact matching information from another sheet will appear in the specific columns.

Like, I have inserted the information in terms master data sheet. In the summery sheet if I input any vendor name, exact matching information of trade term and payment terms will automatically appear in summery sheet’s “R” and “S” column.

In the summery sheet there is already a vba code inserted for updating the date reason. Please help me to solve the above issue.

This is file is here on the below attachment.


hope will get the solution from here.

thanks,

ryan

HI sixthsense,

first of all, thanks for the quick reply. i did like your advise. it is coming out with attached way.

is that possible, not to enter data in vendor section, i mean i will type there ( any of the C COLUMN), and R and S will be
auto updated ?


thanks,

ryan

hi Sixsense,

so much thanks. It is working. I have more hundreds of my vendors list which i want to input, so can you help me to make the formula for the WHOLE :"B,C,D" column, so if any new vendors come, so that i can just input and the data auto appears. currently the formula is only for presented vendors.please..help me. for your easy trace, i am putting the file again.

Regards

ryan

hi sixthsense,

sorry for bothering. i just need your last help.