Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
referencing different workbooks
i have two workbooks. workbook 1 contains 12 columns of
information. the first column is a user key (xyz123 for example) and the following 11 columns are information based on that user key. The other workbook has 2 columns, one containing the user key (xyz123) and the next column has the actual user name (Doe, JOHN). I want to be able to somehow populate the user name onto workbook 1 in the 13th column. Thanks for the help!!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
referencing different workbooks
You can use a worksheet function:
=vlookup(a1,'[my book2.xls]Sheet1'!$A:$B,2,false) in that 13th column. If the key isn't found, you'll get an #n/a back. If you want to hide that, you can wrap the formula with some error checking: =if(iserror(vlookup(...)),"Missing",vlookup(...)) jimmy wrote: i have two workbooks. workbook 1 contains 12 columns of information. the first column is a user key (xyz123 for example) and the following 11 columns are information based on that user key. The other workbook has 2 columns, one containing the user key (xyz123) and the next column has the actual user name (Doe, JOHN). I want to be able to somehow populate the user name onto workbook 1 in the 13th column. Thanks for the help!!! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing Other Workbooks | Excel Discussion (Misc queries) | |||
Referencing other workbooks | Excel Worksheet Functions | |||
Referencing Cells in a different workbooks | Excel Discussion (Misc queries) | |||
Referencing workbooks | New Users to Excel | |||
Referencing other workbooks | Excel Programming |