Google Answers Logo
View Question
Q: Excel File ( Answered 4 out of 5 stars,   0 Comments )
Subject: Excel File
Category: Computers > Software
Asked by: oxbow-ga
List Price: $7.00
Posted: 01 Sep 2006 10:08 PDT
Expires: 01 Oct 2006 10:08 PDT
Question ID: 761417
I would like to format a simple spreadsheet in Excel. What I'd like it
to do, as I enter a row number, is to have the row numbers appear on
another portion of the same the same worksheet. For Example:

    A    B    C    D

1   g    h    j    d                  Enter Row Number Here ==> 3

2   i    n    x    q     Results:        p   z   l   y          

3   p    z    l    y

I am unable to enter the correct formula between the row number that I
enter, the table and the results.

Subject: Re: Excel File
Answered By: maniac-ga on 01 Sep 2006 18:43 PDT
Rated:4 out of 5 stars
Hello Oxbow,

Based on your question, I assume you want the values next to
"Results:" to be updated automatically whenever the Row Number is

One of the easiest way to do this is to use the "INDIRECT" function in
Excel. The indirect function allows you to fetch a value based on a
computed string. I generated the computed string based on the TEXT
function. For more information about the INDIRECT and TEXT functions,
enter those phrases (one at a time) into the Excel help search box.

One of the cell functions I used was
to fetch the Row number from cell G1 (where my "Row Number" happened
to be), reformat that using the TEXT function using the number format
In your example, the generated string is
Then using INDIRECT to use a row / column reference to fetch the value
(in this case, the first column from the third row). The result "p"
appears in the cell with that function. The subsequent result cells
have the formulas:
which fetch the second, third, and fourth column values respectively.
Adjust the cell reference ($G1) to match the cell you have the row
number in it.

If you find the answer unclear or does not completely meet your needs,
please make a clarification request so I can provide further

Good luck with your work.

oxbow-ga rated this answer:4 out of 5 stars and gave an additional tip of: $2.00
A litle confusing at first, but after trying it, worked great! Just what I needed.

There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy