Need help with Dependent drop down boxes

Good afternoon all!

I have been given a spreadsheet consisting of 2 columns of data (county and assigned rep name). What I'm trying to accomplish is - when you select a particular county, the rep assigned automatically populates in the next cell. Is this possible? PLEASE HELP!!!!

I've tried that method, but with our success. Attached is the file I'm working on.

Thank you SO much for your help last ween. I am continuing to work on the same spreadsheet - I am not attempting to connect the corresponding contact information with the selected associate? can you assist me with creating another drop down box?

I think there is an error. When I choose Adams county, Denise should populate the next drop down - however when I do this Mark is populated, not Denise.

DILIpandey where are you entering those formulas? It looks like a data validation drop down list but when I go to data validation there is no formula. Where are you inputing the offset/count if formula?

I have tried for the past few hours to implement this formula into my sheet with no luck. I have searched the internet for any sort of solution to my issue and have not found a solution. So I hope you guys can help. It is along the same lines as the one we just solved... but I will explain further.

I want to have two data validations when I place an order... for each order
1) the first drop down data validation list will allow me to select my vendor
2) the 2nd drop down data validation list will allow me to select products that only that vendor sells.

I accomplished the first data validation using a pivotable from the VendorProducts Sheet. It enabled me to eliminate the duplicate vendors in the product list. Instead of seeing Taylormade, Taylormade, Taylormade then Nike Nike Nike... I now only see my 6 vendors.

However, this is where I am stuck. I want that second list to only list Taylormade products when I select Taylormade from my first list. I thought I would be able to achieve this through pivot tables... which would enable me to have a dynamic range. I would like to be able to add products to my product list and immediately be able to select it in the data validation drop down menu.

I have put together a file with only the pages involved.

On the PJ(Purchase Journal) sheet, I would like to be able to select the vendor and then select from a list of that vendor's products. I hope you guys can help... its been a long night. Much Thanks