#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Forumla between mulitple sheets | Phylis Sophical | Excel | 4 | 08-09-2010 08:43 PM |
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 |
Movement slide with excel sheets | majed | PowerPoint | 4 | 01-17-2009 04:24 PM |