Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 



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 09:29 AM.


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