If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel Formulas
I have an extensive consolidated donor database which
draws information from 5 different databases. All entries are identifiable by a number in column A. The info from database 1 (personal data) features data in columns A-F. Info from database 2 features data in A (to identify it)and then in columns G-I. Info from database 3 features data in column A and then columns J-N... and so on. Can anybody provide me with a formula that will copy data from database 1 (columns B-F)onto any other row with a corresponding identity number in column A? This way, when I am sorting according to data in column M, for example, the personal information in columns B-F will be available too. The alternative, so far as I am aware, is to copy this info with thousands of entries - which doesn't excite me greatly!! Can anyone help? Thanks. |
#2
|
|||
|
|||
Hi
have a look at the VLOOKUP function for this -- Regards Frank Kabel Frankfurt, Germany "J" schrieb im Newsbeitrag ... I have an extensive consolidated donor database which draws information from 5 different databases. All entries are identifiable by a number in column A. The info from database 1 (personal data) features data in columns A-F. Info from database 2 features data in A (to identify it)and then in columns G-I. Info from database 3 features data in column A and then columns J-N... and so on. Can anybody provide me with a formula that will copy data from database 1 (columns B-F)onto any other row with a corresponding identity number in column A? This way, when I am sorting according to data in column M, for example, the personal information in columns B-F will be available too. The alternative, so far as I am aware, is to copy this info with thousands of entries - which doesn't excite me greatly!! Can anyone help? Thanks. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel - Array Formulas - Freeze - VBA Tip? | abc2002 | General Discussion | 1 | August 17th, 2004 09:32 PM |
Add-in functions when starting Excel programmatically | Steve K. | Worksheet Functions | 11 | July 2nd, 2004 06:38 PM |
Coverting Lotus 123 files to use with excel | Muffin1947 | General Discussion | 6 | June 20th, 2004 10:18 AM |
Pointer-like behaviour in Excel possible to build formulas? | Kris Coverdale | Worksheet Functions | 7 | January 14th, 2004 04:10 PM |
Excel 2002 Formulas Book!!! | pobrien31 | Charts and Charting | 1 | October 15th, 2003 08:54 PM |