Dropdown list cell reference

Sorry if this has been covered before, my Google searches have been unproductive. Likely because I don't know exactly what I am looking for.

This is what I am working with:

Sheet #1

Dropdown List | Number | Result 1 | Result 2


Sheet #2

Dropdown List Item 1 | Context Number 1-1 | Context Number 1-2
Dropdown List Item 2 | Context Number 2-1 | Context Number 2-2
etc.


Currently on Sheet #1, Result 1 I have an enormous nested IF statement which does work but seems very inefficient. What I want it to do is select an item from the dropdown list and then apply the context numbers into their respective fields.

Example:

List Item 1 | 55 | =55 * Context Number 1-1 | =55 * Context Number 1-2
List Item 32 | 732 | = 732 * Context Number 32-1 | = 732 * Context Number 32-2

You can avoid long multiple-IF statements by setting up a table and then using a VLOOKUP formula. Post a sample file if you want more details.

Pete