Excel 2010

I am completely stumped and extremely frustrated. Here is my problem (probably something easy, but my brain hurts too much to figure it out):

I have a MASTER sheet that I use to create quotes. It contains all of the components of a building in column B. I want column C to be a drop down menu of lumber choices. Upon selecting the appropriate lumber for the job, I want Excel to automatically fill in column A with the supplier and column M with the price of that said item (D-L have other stuff not concerned with this task). In another sheet, DATA, I have listed the supplier of the lumber (A), the lumber to be selected from the drop down menu (B), and the price (C). I have made the drop down list just fine, but I cannot get Excel to fill in column A or M with the appropriate data. All it returns is "N/A"

Here is the formula I am working with. =IF(ISBLANK(C36),"0.00",VLOOKUP(C36,DATA!A:C,3,0))

When I select 2x4x8 from the drop down list in C, I want Excel to fill in SHOP in A and 2.19 in M.

I do not want to use macros if at all possible.

Any thoughts?