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

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

"pinar" wrote in message
...

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