|
|
#3
09-30-2010, 12:19 AM
|
|||
|
|||
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 
|
|
|
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 |
Windows 7 
Office 2010 (Version 14.0)
Threaded Mode