I have a list of information on Sheet3, and a drop-down list on Sheet1 that pulls its information from the list on Sheet3. When I select an item in my drop-down, which is in column A, I want it to automatically fill in the information in column C according to whatever it is that I select in column A, for example I select a particular product in the drop-down, and its price show up in column C. How do I do this? I have use the IF function and it works for the first product, but the other products in the drop down don't. I need to put multiple IF functions in one cell I think. How does that work? Thank you!