Lookup text return column

[jammerdk]

Hi there guys

i'm trying to lookup a text in a certain row (Row 10) and the return the column, and do a freqency calculation on the data beneath Row 10 in that particular column.

 

[Aladin Akyurek]

Hi there guys

i'm trying to lookup a text in a certain row (Row 10) and the return the column, and do a freqency calculation on the data beneath Row 10 in that particular column.

That's a bit terse... Could you post a tiny sample along with the desired result?

 

[T. Valko]

Hi there guys

i'm trying to lookup a text in a certain row (Row 10) and the return the column, and do a freqency calculation on the data beneath Row 10 in that particular column.

Tell us what text you're looking for and what it is you want to count when we find the correct column.

It helps when you're more specific by including cell/range adresses.

 

[jammerdk]

okay...here goes nothing

example Sheet 1
-------A-------------B-------------C---------D---------E----------F
10. Date-----------Time-------Ra µm---Rq µm---Rz µm---Rmax µm
11. 16-09-2008--1:03 AM-----0,4433---0,6210---2,2840---3,6952
12. 16-09-2008--1:04 AM-----0,2376---0,3013---1,1747---1,4442
13. 16-09-2008--1:05 AM-----0,2655---0,3367---1,2736---1,5560
14. 16-09-2008--1:06 AM-----0,5702---0,7595---2,5127---3,6740
15. 16-09-2008--1:07 AM-----0,4178---0,5897---2,5983---3,9590
16. 16-09-2008--11:12 PM--- 0,4797---0,5978---2,3606---2,8376
17. 16-09-2008--11:13 PM--- 0,3584---0,4729---1,9547---2,6071
18. 16-09-2008--11:14 PM--- 0,4127---0,5802---2,0382---3,5653
19. 16-09-2008--11:15 PM--- 0,4059---0,5570---2,1986---3,0716
20. 16-09-2008--11:15 PM--- 0,3001---0,4028---1,5144---2,5708


In Sheet 2 cell A1 can the values Ra, Rq, Rz, Rmax be selected and like to return the column data from the certain row beneath the text

Ex. Cell Value A1 = Ra returns the values from Column C in Column A Sheet 2

0,4433
0,2376
0,2655
0,5702
0,4178
0,4797
0,3584
0,4127
0,4059
0,3001

 

[T. Valko]

okay...here goes nothing

example Sheet 1
-------A-------------B-------------C---------D---------E----------F
10. Date-----------Time-------Ra µm---Rq µm---Rz µm---Rmax µm
11. 16-09-2008--1:03 AM-----0,4433---0,6210---2,2840---3,6952
12. 16-09-2008--1:04 AM-----0,2376---0,3013---1,1747---1,4442
13. 16-09-2008--1:05 AM-----0,2655---0,3367---1,2736---1,5560
14. 16-09-2008--1:06 AM-----0,5702---0,7595---2,5127---3,6740
15. 16-09-2008--1:07 AM-----0,4178---0,5897---2,5983---3,9590
16. 16-09-2008--11:12 PM--- 0,4797---0,5978---2,3606---2,8376
17. 16-09-2008--11:13 PM--- 0,3584---0,4729---1,9547---2,6071
18. 16-09-2008--11:14 PM--- 0,4127---0,5802---2,0382---3,5653
19. 16-09-2008--11:15 PM--- 0,4059---0,5570---2,1986---3,0716
20. 16-09-2008--11:15 PM--- 0,3001---0,4028---1,5144---2,5708


In Sheet 2 cell A1 can the values Ra, Rq, Rz, Rmax be selected and like to return the column data from the certain row beneath the text

Ex. Cell Value A1 = Ra returns the values from Column C in Column A Sheet 2

0,4433
0,2376
0,2655
0,5702
0,4178
0,4797
0,3584
0,4127
0,4059
0,3001

Try this...

Entered on Sheet2 A2 and copied down as needed:

=INDEX(Sheet1!C$11:F$20,ROWS(A$2:A2),MATCH(A$1&"*",Sheet1!C$10:F$10,0))