Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Excel Worksheet Functions | |||
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Excel Discussion (Misc queries) | |||
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Links and Linking in Excel | |||
Seo , Search Engine Optimizer , Seo Search engine Optimization , search engine optimization services, SEO Consulting | Charts and Charting in Excel | |||
How do I search excel spreadsheets using multiple search criteria. | Excel Worksheet Functions |