Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-29-2010, 06:56 AM
diegogeid diegogeid is offline How to syncronize data in two different sheets Windows 7 How to syncronize data in two different sheets Office 2010 (Version 14.0)
Novice
How to syncronize data in two different sheets
 
Join Date: Sep 2010
Posts: 4
diegogeid is on a distinguished road
Default How to syncronize data in two different sheets

I have a sheet with two columns and some data, and another sheet with a column and the same data of the first column in the first sheet, but in a different position. So, i need to insert in the column 2 of the second sheet the correct data.
How can i do it?

Example:

_Sheet 1:

Column1 Column2
A 1
B 2


C 3

_Sheet 2:

Column1 Column2
if B --> 2
if C --> 3
if A --> 1


Thanks
Diego
Reply With Quote
  #2  
Old 09-29-2010, 01:10 PM
Kimberly Kimberly is offline How to syncronize data in two different sheets Windows 7 How to syncronize data in two different sheets Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Posts: 517
Kimberly is on a distinguished road
Default

something like this:

=VLOOKUP(A1,Sheet1!$A$1:$B$3,2,0)

change A1 to the location of the first cell of data in what you have listed as "Column 1" on Sheet2.

change A$1:$B$3 to the location of your table of data on Sheet1.

copy down.
Reply With Quote
  #3  
Old 09-30-2010, 12:19 AM
diegogeid diegogeid is offline How to syncronize data in two different sheets Windows 7 How to syncronize data in two different sheets Office 2010 (Version 14.0)
Novice
How to syncronize data in two different sheets
 
Join Date: Sep 2010
Posts: 4
diegogeid is on a distinguished road
Default

It seems to work with:

=CERCA(A4;'Sheet1'!B2:B213;'Sheet1'!F2:F213)

Note:
A4 = firts cell with data in the column1 on sheet 2
B2:B213 = cells with data in the column1 on sheet 1
F2:F213 = cells with data in the column2 on sheet 1


N.B.: my Excel is in Italian, so the word "cerca" it should be your "vlookup"

Thanks
Diego
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to syncronize data in two different sheets Forumla between mulitple sheets Phylis Sophical Excel 4 08-09-2010 08:43 PM
How to syncronize data in two different sheets How do I merge data from one sheet in a workbook out into multiple sheets nolesca Excel 4 06-07-2010 08:13 AM
Print Multiple Sheets Double-Sided flambe99 Excel 1 03-12-2010 01:15 PM
unwanted sheets on opening excel msofficeman Excel 3 02-24-2009 03:13 PM
How to syncronize data in two different sheets Movement slide with excel sheets majed PowerPoint 4 01-17-2009 04:24 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:47 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft