Help pull data from a cell in another sheet compiled from three cell variables

[photodotexe]

Hey there!!

I have a sheet called "exchange", and cell B1 has a variable name of "heavySteelToSteel".

In my other sheet called "calculator", I'd like to pull the data from exchange!heavySteelToSteel, which is extremely easy. However - I'd like to do it using three variables. You see, I have three drop-down menus in "calculator". In one of them (C1), you can choose "heavy", "light", or other things - you get the idea. In the other TWO (C2 and C3), you can select "steel", "iron", "aluminum", "graphite", etc.

What I'm trying to do, is something like this in the "calculator" sheet:

=exchange!calculator!C1&calculator!C2&to&"calculator!C3 - basically I want to form "heavySteelToSteel" using three variables from data in cells.

This is NOT working. I feel like I'm approaching this incorrectly. Any guidance?? Thanks!!

[daffodil11]

You will need to use the INDIRECT function to have strings evaluated as references.

=INDIRECT("Exchange!"&C1&C2&C3)

If the named reference was created with 'Applies to Workbook' instead of 'Applies to Worksheet' you could just simply put:

=INDIRECT(C1&C2&C3)

[photodotexe]

Thank you!!