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