|
|
#2
09-29-2010, 01:10 PM
|
|||
|
|||
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. 
|
| 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 |
Windows 7 
Office 2010 (Version 14.0)
Threaded Mode