On Thu, 21 Apr 2005 20:59:01 -0700, "ST" wrote:

I want to look up a value from a range of columns and rows.
For example, Wat is the value ast Column C Row D?

What is the fundtion to use?

In Excel, using the A1 scheme, Columns are usually referenced by letters and
Rows by numbers.

But there are many different solutions depending on your specifics.

Depending on how your data is entered, you could use the intersection operator:

=Sheet1!2:2 Sheet1!C:C

would give you the value at cell C2.

If you are having the user enter the row in A1 (=2) and the column in B1 (=C)
(on a sheet other than your data), you could use the formula:

=INDIRECT("Sheet1!"&B1&A1)

If he is also entering the Sheet reference in, let us say, C1, and the column
NUMBER (instead of the column LETTER) then you could use the formula:

=INDIRECT(ADDRESS(A1,B1,,,C1))

You should be able to figure out something given this information.

Check out HELP for the intersection operator and the above mentioned functions.


--ron