Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
pinar
 
Posts: n/a
Default getting data from 2 different exc sheet


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

  #2   Report Post  
Bernie Deitrick
 
Posts: n/a
Default

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
List, Data Validation, unlocked cell, protected sheet..... Kane New Users to Excel 6 July 16th 12 09:11 AM
enter data on 1 sheet and make it enter on next avail row on 2nd s Nadia Excel Discussion (Misc queries) 27 September 9th 05 03:39 PM
Transfer data from sheet to sheet Jenn Excel Discussion (Misc queries) 4 January 20th 05 04:07 PM
Automatioc spill over data to a new Excel sheet from Xml source? Sruthi Excel Discussion (Misc queries) 0 December 6th 04 07:31 PM
Naming & renaming a sheet tab Cgbilliar Excel Worksheet Functions 1 November 7th 04 06:57 PM


All times are GMT +1. The time now is 02:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"