Hello,
I have two sheets in my workbook. One is a list ('LIST') of customer names, the products they make, and each products cost.

The second sheet ('Tally') will be filled in by users. So far I have set them up with data validation to have pull down menus (based on named lists on 'LIST'). Also, have an indirect reference to give users the appropriate list of products based on the customer they select.

Now, I am trying to figure out how to get the price to automatically fill in based on the product chosen in 'TALLY'.

Based on what I have looked up, I think it is an "INDEX", but I am not sure of the logic in that formula.

Any help would be much appreciated.

PS-
I have a sample workbook that I tried to attach (manage attachments below) but it won't let me post it - says "error-invalid file". If someone can let me know how to do that properly, I will attach my workbook.

Thank you!