Could you please help me with this matter?

The column found came from a text file.
Number Call test Found
1 t gg 6
2 t rr 10
3 u de 14
4 j ty 20
5 y hu
6 u ed
7 j gt
8 d vf
9 b ki
10 h yh
11 k bg
12 u ed
13 t sw
14 t rt
15 g mk
16 n lo
17 h uy
18 g hg
19 h rt
20 m vf

Then I want to get the information in another sheet which correspond under
the column Call and Test, as shown below:
Found Call test
6 u ed
10 h yh
14 t rt
20 m vf

I will appreciate your helping.
Thanks in advance.
Maperalia

I forgot to ask if this procedure can be done with any excel's formula.
Thanks.
Maperalia

"maperalia" wrote:

Could you please help me with this matter?

The column found came from a text file.
Number Call test Found
1 t gg 6
2 t rr 10
3 u de 14
4 j ty 20
5 y hu
6 u ed
7 j gt
8 d vf
9 b ki
10 h yh
11 k bg
12 u ed
13 t sw
14 t rt
15 g mk
16 n lo
17 h uy
18 g hg
19 h rt
20 m vf

Then I want to get the information in another sheet which correspond under
the column Call and Test, as shown below:
Found Call test
6 u ed
10 h yh
14 t rt
20 m vf

I will appreciate your helping.
Thanks in advance.
Maperalia

I'm assuming that under the header "Found" are the numbers 6, 10, 14, 20?

assume the table on Sheet1 is in the range A1:D21 (row 1 are column headers)

Enter this formula on Sheet2 in cell A2:

=IF(Sheet1!D2="","",Sheet1!D2)

Enter this formula on Sheet2 in cell B2 and copy across to cell C2:

=IF($A2="","",VLOOKUP($A2,Sheet1!$A$2:$C$21,COLUMN S(Sheet1!$A:B),0))

Select cells A2:C2 and copy down until you get blanks.

Biff

"maperalia" wrote in message
...
Could you please help me with this matter?

The column found came from a text file.
Number Call test Found
1 t gg 6
2 t rr 10
3 u de 14
4 j ty 20
5 y hu
6 u ed
7 j gt
8 d vf
9 b ki
10 h yh
11 k bg
12 u ed
13 t sw
14 t rt
15 g mk
16 n lo
17 h uy
18 g hg
19 h rt
20 m vf

Then I want to get the information in another sheet which correspond under
the column Call and Test, as shown below:
Found Call test
6 u ed
10 h yh
14 t rt
20 m vf

I will appreciate your helping.
Thanks in advance.
Maperalia

Valko;
Thanks for your quick response.
I setuped the formulas as you described, however, I got nothing in the
sheet2. Besides, when I type the information in the column "D" of the sheet 1
I got error on the sheet 2.
Could you please tell me what I did wrong or I wonder if you can send me the
file sample to my e-mail address: .

Thanks.
Maperalia

"T. Valko" wrote:

I'm assuming that under the header "Found" are the numbers 6, 10, 14, 20?

assume the table on Sheet1 is in the range A1:D21 (row 1 are column headers)

Enter this formula on Sheet2 in cell A2:

=IF(Sheet1!D2="","",Sheet1!D2)

Enter this formula on Sheet2 in cell B2 and copy across to cell C2:

=IF($A2="","",VLOOKUP($A2,Sheet1!$A$2:$C$21,COLUMN S(Sheet1!$A:B),0))

Select cells A2:C2 and copy down until you get blanks.

Biff

"maperalia" wrote in message
...
Could you please help me with this matter?

The column found came from a text file.
Number Call test Found
1 t gg 6
2 t rr 10
3 u de 14
4 j ty 20
5 y hu
6 u ed
7 j gt
8 d vf
9 b ki
10 h yh
11 k bg
12 u ed
13 t sw
14 t rt
15 g mk
16 n lo
17 h uy
18 g hg
19 h rt
20 m vf

Then I want to get the information in another sheet which correspond under
the column Call and Test, as shown below:
Found Call test
6 u ed
10 h yh
14 t rt
20 m vf

I will appreciate your helping.
Thanks in advance.
Maperalia

Here's a sample file:

sample_lookup.xls 15kb

http://cjoint.com/?mmuQLYWJHo

Biff

"maperalia" wrote in message
...
Valko;
Thanks for your quick response.
I setuped the formulas as you described, however, I got nothing in the
sheet2. Besides, when I type the information in the column "D" of the
sheet 1
I got error on the sheet 2.
Could you please tell me what I did wrong or I wonder if you can send me
the
file sample to my e-mail address: .

Thanks.
Maperalia

"T. Valko" wrote:

I'm assuming that under the header "Found" are the numbers 6, 10, 14, 20?

assume the table on Sheet1 is in the range A1:D21 (row 1 are column
headers)

Enter this formula on Sheet2 in cell A2:

=IF(Sheet1!D2="","",Sheet1!D2)

Enter this formula on Sheet2 in cell B2 and copy across to cell C2:

=IF($A2="","",VLOOKUP($A2,Sheet1!$A$2:$C$21,COLUMN S(Sheet1!$A:B),0))

Select cells A2:C2 and copy down until you get blanks.

Biff

"maperalia" wrote in message
...
Could you please help me with this matter?

The column found came from a text file.
Number Call test Found
1 t gg 6
2 t rr 10
3 u de 14
4 j ty 20
5 y hu
6 u ed
7 j gt
8 d vf
9 b ki
10 h yh
11 k bg
12 u ed
13 t sw
14 t rt
15 g mk
16 n lo
17 h uy
18 g hg
19 h rt
20 m vf

Then I want to get the information in another sheet which correspond
under
the column Call and Test, as shown below:
Found Call test
6 u ed
10 h yh
14 t rt
20 m vf

I will appreciate your helping.
Thanks in advance.
Maperalia

Valko;
Thanks you very much. It it running perfectly!!!
However, I move the data on the sheet 2 to start from B2 and left the column
"A" empty. Also I moved the data on the sheet 1 to type dates in the coumn
"A". However, I can get make the formula to read it in the left column for
this dates.
Ii is possible to do that..

Thanks in advance.
Maperalia


"T. Valko" wrote:

Here's a sample file:

sample_lookup.xls 15kb

http://cjoint.com/?mmuQLYWJHo

Biff

"maperalia" wrote in message
...
Valko;
Thanks for your quick response.
I setuped the formulas as you described, however, I got nothing in the
sheet2. Besides, when I type the information in the column "D" of the
sheet 1
I got error on the sheet 2.
Could you please tell me what I did wrong or I wonder if you can send me
the
file sample to my e-mail address: .

Thanks.
Maperalia

"T. Valko" wrote:

I'm assuming that under the header "Found" are the numbers 6, 10, 14, 20?

assume the table on Sheet1 is in the range A1:D21 (row 1 are column
headers)

Enter this formula on Sheet2 in cell A2:

=IF(Sheet1!D2="","",Sheet1!D2)

Enter this formula on Sheet2 in cell B2 and copy across to cell C2:

=IF($A2="","",VLOOKUP($A2,Sheet1!$A$2:$C$21,COLUMN S(Sheet1!$A:B),0))

Select cells A2:C2 and copy down until you get blanks.

Biff

"maperalia" wrote in message
...
Could you please help me with this matter?

The column found came from a text file.
Number Call test Found
1 t gg 6
2 t rr 10
3 u de 14
4 j ty 20
5 y hu
6 u ed
7 j gt
8 d vf
9 b ki
10 h yh
11 k bg
12 u ed
13 t sw
14 t rt
15 g mk
16 n lo
17 h uy
18 g hg
19 h rt
20 m vf

Then I want to get the information in another sheet which correspond
under
the column Call and Test, as shown below:
Found Call test
6 u ed
10 h yh
14 t rt
20 m vf

I will appreciate your helping.
Thanks in advance.
Maperalia

Here's an updated sample file:

http://cjoint.com/?mneAXpQFoi

Biff

"maperalia" wrote in message
...
Valko;
Thanks you very much. It it running perfectly!!!
However, I move the data on the sheet 2 to start from B2 and left the
column
"A" empty. Also I moved the data on the sheet 1 to type dates in the coumn
"A". However, I can get make the formula to read it in the left column for
this dates.
Ii is possible to do that..

Thanks in advance.
Maperalia


"T. Valko" wrote:

Here's a sample file:

sample_lookup.xls 15kb

http://cjoint.com/?mmuQLYWJHo

Biff

"maperalia" wrote in message
...
Valko;
Thanks for your quick response.
I setuped the formulas as you described, however, I got nothing in the
sheet2. Besides, when I type the information in the column "D" of the
sheet 1
I got error on the sheet 2.
Could you please tell me what I did wrong or I wonder if you can send
me
the
file sample to my e-mail address: .

Thanks.
Maperalia

"T. Valko" wrote:

I'm assuming that under the header "Found" are the numbers 6, 10, 14,
20?

assume the table on Sheet1 is in the range A1:D21 (row 1 are column
headers)

Enter this formula on Sheet2 in cell A2:

=IF(Sheet1!D2="","",Sheet1!D2)

Enter this formula on Sheet2 in cell B2 and copy across to cell C2:

=IF($A2="","",VLOOKUP($A2,Sheet1!$A$2:$C$21,COLUMN S(Sheet1!$A:B),0))

Select cells A2:C2 and copy down until you get blanks.

Biff

"maperalia" wrote in message
...
Could you please help me with this matter?

The column found came from a text file.
Number Call test Found
1 t gg 6
2 t rr 10
3 u de 14
4 j ty 20
5 y hu
6 u ed
7 j gt
8 d vf
9 b ki
10 h yh
11 k bg
12 u ed
13 t sw
14 t rt
15 g mk
16 n lo
17 h uy
18 g hg
19 h rt
20 m vf

Then I want to get the information in another sheet which correspond
under
the column Call and Test, as shown below:
Found Call test
6 u ed
10 h yh
14 t rt
20 m vf

I will appreciate your helping.
Thanks in advance.
Maperalia