MS Excel: How to return specific row within column based on numeric input?

Forums: Software, Excel
Email this Topic • Print this Page

Hi everyone and a happy new year to all.

Is it possible to return the contents of a cell based on its numeric (row) location?

For example, suppose each cell in column C contains various types of data, suppose I am using cell A1 for input, and suppose I am using cell A2 for output.
In this case, is there a formula for cell A2 which would return a specific row in column C after entering a number in cell A1? (If I enter the number “5” in A1, A2 displays the contents of C5; if I enter the number “7” in A1, A2 displays the contents of C7; “10” displays C10, and so on).

Thanks beforehand for your help.

Topic Stats
Top Replies
Link to this Topic

Type: Question • Score: 0 • Views: 1,930 • Replies: 6

[+3] - timur - 01/02/2013No VB needed. There is a simple function to solve it: Indirect (cell address). Look here: [img] http://imageshack.us/scaled/large/99/formula1n.jpg[/img] Still, you need to put your full...

@investor,

Huh.

You might need vb code for this.

1 Reply

@jespah,

No VB needed.

There is a simple function to solve it:
Indirect (cell address).

Look here:

http://imageshack.us/scaled/large/99/formula1n.jpg

Still, you need to put your full address in your first cell.
If you don't want to bother with putting the column letter in there, you can concatenate two columns, one of them being your fixed data column, and then hide the ones you don't want to see.

Look here an example:

http://imageshack.us/scaled/large/99/formula2.jpg

Use B1 to enter your data cell address and hide A1 and C1.

2 Replies

@timur,

Hey, thanks.

1 Reply

@jespah,

My pleasure...

0 Replies

@timur,

Excellent. Thank you very much.

1 Reply

@investor,

You are welcome.

0 Replies

MS Excel: How to return specific row within column based on numeric input?

Related Topics

Quick Links

My Account

able2know