Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Allen Way via OfficeKB.com
 
Posts: n/a
Default combining data from multiple sheets

I have two worksheets each with different employee data: names, job title,
shift, days off, etc. All the employees in the 2nd sheet are also in the
1st; only some of those in the 1st are in the 2nd. The 2nd is kind of a
subset of the first, however, the only column the two have in common is
Name. I want to combine the two sheets so the info from the 2nd is placed
into new columns in the correct rows of the first. How?

--Allen

--
Message posted via http://www.officekb.com
  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi Allen

using VLOOKUP

say in Sheet 2 you've got
..........A...........B..............C
1....Name.....Hire Date...Dog's Name

and in sheet 1 you've got stuff all the way to column H and you want Hire
Date from sheet to in column I and Dog's Name in column J
the formula for I2 in sheet 1 would be
=VLOOKUP(A2,Sheet2!$A$2:$C$100,2,0)
and the formula for J2 would be
=VLOOKUP(A2,Sheet2!$A$2:$C$100,3,0)

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Allen Way via OfficeKB.com" wrote in message
...
I have two worksheets each with different employee data: names, job title,
shift, days off, etc. All the employees in the 2nd sheet are also in the
1st; only some of those in the 1st are in the 2nd. The 2nd is kind of a
subset of the first, however, the only column the two have in common is
Name. I want to combine the two sheets so the info from the 2nd is placed
into new columns in the correct rows of the first. How?

--Allen

--
Message posted via http://www.officekb.com



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
Updating Excel Data on Multiple Sheets Juana Cafe Excel Worksheet Functions 3 February 28th 05 10:04 PM
Question about combining data from multiple workbooks into one rep BookOpenandUpright Excel Discussion (Misc queries) 2 February 19th 05 01:37 PM
Combining data (numeric format) in multiple cells into one cell (t GNAC SID Excel Discussion (Misc queries) 2 February 7th 05 05:09 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 06:55 PM
Summarise data on multiple sheets Jules Excel Worksheet Functions 4 December 1st 04 06:01 PM


All times are GMT +1. The time now is 05:08 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"