problems with forming sheets

[pinar]

PHP code
-------------------
Hello

I have a problem that is a bit complicated for me.
Is there anybody who has idea?

I have 2 excel sheets.

In the first sheet , there is a lot of data like

Column A Column B Column E
Model Name Price1
1000 ABC 20
1003 ASC 10
1004 WSX 30
1005 EDF 20

And in the second one, there is also a lot of data with price 2.

Column A Column B Column F
Model Name Price2
1000 ABC 40
1003 ASC 30
1004 WSX 20
1005 EDF 10

What I need is to form automatically another excel sheet for specific models, for example
I need model 1000 and 1004. and their price info. Price 1 info has to come from sheet 1 and Price 2 info has to come from sheet 2 and form the sheet below. but the thing is it has to take the right data from the excel sheets automatically.

Column A Column B Column E Column F
Model Name Price 1 Price2
1000 ABC 20 40
1004 WSX 30 20


Is there any way to do it without any macro?
Thnks a lo

 

[Frank Kabel]

Hi
how do you want to define your models.Would you enter them manually in
sheet 3. If yes VLOOKUP should do the trick. See:
http://www.contextures.com/xlFunctions02.html

--
Regards
Frank Kabel
Frankfurt, Germany

PHP code:
--------------------
Hello

I have a problem that is a bit complicated for me.
Is there anybody who has idea?

I have 2 excel sheets.

In the first sheet , there is a lot of data like

Column A Column B Column E
Model Name Price1
1000 ABC 20
1003 ASC 10
1004 WSX 30
1005 EDF 20

And in the second one, there is also a lot of data with price 2.

Column A Column B Column F
Model Name Price2
1000 ABC 40
1003 ASC 30
1004 WSX 20
1005 EDF 10

What I need is to form automatically another excel sheet for specific models, for example
I need model 1000 and 1004. and their price info. Price 1 info has

to come from sheet 1 and Price 2 info has to come from sheet 2 and form
the sheet below. but the thing is it has to take the right data from
the excel sheets automatically.