getting data from 2 different exc sheet

[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

 

[Bernie Deitrick]

Pinar,

You could use VLOOKUP formulas, if your Model numbers are unique. Just make
sure you use the fourth parameter set to False.

HTH,
Bernie
MS Excel MVP

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.