|
|
#2
01-09-2013, 08:53 AM
|
|||
|
|||
Hi
The easiest way to achieve what you want is to transpose your source data from columns to rows. Then use your formula as normal i.e. =Sheet1!C5 and then drag it down your target column and it will pick up the correct values from your source data. Good luck. Tony 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Transpose Issue (need custom increment on auto fill down)
|
gretchen | Excel | 3 | 11-28-2012 02:33 PM |
| How to transpose the datas of part code and supplier into row and column | PRADEEPB270 | Excel | 3 | 10-26-2012 07:22 PM |
|
skip to next sentence?
|
moreenz | Word | 3 | 08-16-2012 02:41 PM |
|
skip duplicate letters
|
karen h | Mail Merge | 10 | 03-23-2011 08:37 AM |
| How to skip the credential checking step | charleslt1900 | Outlook | 2 | 08-19-2010 04:02 PM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode