![]() |
#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 | Thread Starter | Forum | Replies | Last Post |
![]() |
Phylis Sophical | Excel | 4 | 08-09-2010 08:43 PM |
![]() |
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 |
![]() |
majed | PowerPoint | 4 | 01-17-2009 04:24 PM |