Assign Value from comparison of another cell

[epr1977]

Hello everyone,

First of all, i want to say that this is a great forum with great resources in excel...

I'm not sure if this is the proper section to post this question, but i think the response for my question might require a little bit of Programming.

I have an excel file with two worksheets (simulation attached). The first worksheet has something like a 'form' but without fileds . But it's divided in two sections (english & spanish); I just did a 'quick' formula to assign most of the values of the form, but they're 3 'fields' that are from a 'name list' on the second worksheet (to use a 'drop-down' menu).

My problem is that when I try to assign those values into the 'spanish' section, I must use the second list on the other workseet (Spanish values). My first try was trying to have a big IF to compare all the options, something like this:

This is Excel formula code ok? not VB code

Code:
=IF((LEFT(A10,3)="(a)"),'Drop Down Menus'!C4,(IF((LEFT(A10,5)="(a.1)"),'Drop Down Menus'!C5,.......{an so on.}...But since my list it's kinda big (about 40 itmes)...I think i'm limited to use certain IF's....

I know a little (just a little) of VB programming (mainly for Access), but i've never work with anything for excel... so I'm kinda lost in how to control/access the excel document items.... (cell ,worksheets...etc...)....

Is there a way I can get some light on how to solve this problem?

Edit-------

Opps i forgot the file....