Hi guys,

I'm fairly simple when it comes to formulas which is why I am posting in this forum. I'm creating a purchase order system for my employer and could use some help. I have a list of suppliers in column C which is on the worksheet named 'PO Settings' and next to that in column D I have addresses and contact info for each of them. On another sheet I am creating a purchase order template and I have made a drop down list for each of the suppliers from that PO Settings worksheet, under that I am looking to put the address which can be found next to column C on the PO Settings worksheet but for the address to automatically match the suppliers name.

Any suggestions?