Posts by amberskipper22

Quick question for the Excel experts out there 🙂. I wouldn't call myself a total novice, but I haven't spent much time messing around with complex functions. Here’s the situation. I have a workbook with 13 sheets—one for each month, plus a sheet called naknade. In the naknade sheet, I have "name of thing" and "Price." In the "January" sheet, the columns are "First Name," "Last Name," "Thing," "Thing1," and "Thing2." Here is what I need: if someone selects "Lamb" from a dropdown menu, I want it to pull the price for lamb and put it in the "Total" field. Furthermore, if "lamb" is also selected in "Thing1" on that same row, I want it to add that price to the first one. I've tried to be as specific as possible, and I've attached the table below. If anyone knows the simplest way to handle this, I'll buy you a beer 🙂. Here is the link to the test workbook http://rapidshare.com/files/456907421/Test.xlsx