Referencing cells on a separate sheet based on pull down menu response

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!

It is a .xls file and is less than 1000kb. It still has the same error. I am on a Mac using OS v.X if that makes any difference??

Ahh, zipping it looks like it worked. Here is the attachment.

Thanks!

Well, shoot... When I click on the link I see on the forum it opens the excel file. I just compressed my original file and attached that one. I am at a loss... what else can I try?

Thanks for your patience.
-Jen