Extract values to copy in another table
 

Could you please help me with this matter?

I wonder if there is any Excel's formula to do the following procedu
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 the formula to copy the information which correspond under
the column "Call" and "Test" and get the following result as shown below:
Found Call test
6 u ed
10 h yh
14 t rt
20 m vf

I will appreciate your helping me.
Thanks in advance.
Maperalia

Extract values to copy in another table
 

Have a look at the Vlookup function:
With the help of this function you should get the things you want to have!

Hth

Carlo


"maperalia" wrote:

Could you please help me with this matter?

I wonder if there is any Excel's formula to do the following procedu
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 the formula to copy the information which correspond under
the column "Call" and "Test" and get the following result as shown below:
Found Call test
6 u ed
10 h yh
14 t rt
20 m vf

I will appreciate your helping me.
Thanks in advance.
Maperalia