Formula for obtaining values on separate sheet from values declared on current sheet?

i have a workbook with two sheets. lets just call them sheet 1 and sheet 2.

on sheet 1 i have data for employees and their current wages and other info.

on sheet 2 the data is for compensation scale on three separate columns.

so on sheet 1 looks like this:

A B C D E

1 Doe John B 3 20,000


so on sheet two looks something like this:

A B C

1 17,000 19,000 21,000

2 17,500 19,500 21,500

3 18,000 20,000 22,000

4 18,500 20,500 22,500

5 19,000 21,000 23,000

6 19,500 21,500 23,500


in order for me to automatically get the data from (sheet 2 B3) the formula for sheet 1 E1 would be: ='Sheet 1'!B3

how do i formulate the equation so that i can do ='Sheet 2'!(C1)(D1) ?

in other words i want to specify the column and row from the values declared in sheet 1 column c and column d respectively.

Any help is greatly appreciated.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Thanks for taking the time to read and comply with the rule .

Do you mean?

=INDIRECT("'Sheet 2'!"&C1&D1)

Where C1 contains the column letter and D1 contains the row number.

No problem.

Can you now please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save