Try this:

=INDIRECT(A8&B8)

HTH,
Elkar


"ek" wrote:

Below is a sample of a spreadsheet that I am using. The top part is my "raw
data area", and the bottom part is my "calculation area". I want to create a
formula in C8 that references A8 for the column, and B8 for the row. So when
I drag C10 down it will reference A11 and B11, etc. Can anyone help me? Thank
you.

A B C
1 Data Area
2 Red Yellow
3 Blue Green
4 Purple Orange
5 Pink Black

6 Calculation area
7 Column Row Response
8 A 3 Red
9 B 3 Yellow