Cross reference cell

[Pheng]

Hi all,

I'm in the process of streamlining a chart that we work by.

It has 42 columns down and 7 Rows across.

I want to be able to select from a reference column and a row and have
Excel perform the calculations based on the result of the cross
references.

For example:

* I can select Row 4 in one cell
* I can then select Column 2 in another cell

The result would be a figure. This figure will then be calculated to
give me the answer I wanted.

Therefore the choices range from 294 results (42 x 7)

Cheers,

 

[Biff]

Hi!

Do you have headers for the columns and rows?

You could use a simple vlookup/match:

=VLOOKUP(A1,C2:H7,MATCH(B1,C2:H2,0),0)

A1 = row lookup
B1 = column lookup

Biff

 

[Arvi Laanemets]

Hi

P.e. with your table in range A1:AP7, and searched row and column values in
cells A11:A12
=INDEX(A1:AP7,A11,A12)