search
 

-page1-
name price daily advantage
1 ABANA 0.00 0.00
2 ACIBD 8.45 0.60
3 ADANA 7.95 0.63
4 ADBGR 4.76 -0.83
5 ADEL 6.30 0.80
6 ADNAC 0.78 -1.27
7 AEFES 12.50 2.46
8 AFMAS 4.96 0.81
9 AFYON 970.00 1.04
10 AGYO 2.46 2.93
11 AKALT 1.82 -0.55
12 AKBNK 9.20 1.66
13 AKCNS 8.10 0.62
14 AKENR 10.60 0.00
15 AKGRT 7.85 0.64
--------------------------------------------
- page2-
1 if i write whatever name in A1 column, how can i bring automaticly it's
"price" and "daily advantage" in B1 column from page1 ?

example:
name price daily advantage
2 AKBNK (i need formul for price) (i need formul daily advantage of AKBANK)
3 ADEL I want to write automaticly to price of ADEL
4 AFYON
5 AGYO
6 AKENR

search
 

for price
=VLOOKUP(A2,page1!A:B,2,FALSE)
for daily advantage
=VLOOKUP(A2,page1!A:C,3,FALSE)

Regards,
Stefi


€žarslanmustafa€� ezt Ã*rta:

-page1-
name price daily advantage
1 ABANA 0.00 0.00
2 ACIBD 8.45 0.60
3 ADANA 7.95 0.63
4 ADBGR 4.76 -0.83
5 ADEL 6.30 0.80
6 ADNAC 0.78 -1.27
7 AEFES 12.50 2.46
8 AFMAS 4.96 0.81
9 AFYON 970.00 1.04
10 AGYO 2.46 2.93
11 AKALT 1.82 -0.55
12 AKBNK 9.20 1.66
13 AKCNS 8.10 0.62
14 AKENR 10.60 0.00
15 AKGRT 7.85 0.64
--------------------------------------------
- page2-
1 if i write whatever name in A1 column, how can i bring automaticly it's
"price" and "daily advantage" in B1 column from page1 ?

example:
name price daily advantage
2 AKBNK (i need formul for price) (i need formul daily advantage of AKBANK)
3 ADEL I want to write automaticly to price of ADEL
4 AFYON
5 AGYO
6 AKENR