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

[XtianDg]

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.