Using a cell in formula to create a reference

E

ek

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top