Formula:
--------------------
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 lot
--------------------


--
pinar
------------------------------------------------------------------------
pinar's Profile: http://www.excelforum.com/member.php...o&userid=16067
View this thread: http://www.excelforum.com/showthread...hreadid=276558