Thread: [Solved] How to syncronize data in two different sheets
View Single Post
 
Old 09-30-2010, 12:19 AM
diegogeid diegogeid is offline Windows 7 Office 2010 (Version 14.0)
Novice
  
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