Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging/Combining workbook data
I have two workbooks, one worksheet in each.
Workbook one contains customer data A1:K362 Column C is blank and is where I need to enter the cutomers fgt acct numbers which are in workbook two. ColA ColB ColC ColD ColE Cust# FgtCarrier FgtAcct# CustName CustAdd Workbook two contains two columns A1:B570 ColA ColB Cust# FgtAcct# ColA from both worksheets contain the customer numbers, although not all customers are listed on the worksheet in workbook one. I need to fill in ColB with the fgt account numbers. Rather than manually going through both lists to match up customer acct. and then enter the corresponding fgt. number I am hoping there is another way. If the cust numbers in ColA match on both worksheets than enter the fgt acct number for the corresponding cust. acct (located in ColB on workbook2) in ColC on workbook 1. Thank you Lee |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging/Combining workbook data
Gimi,
you can use the formula "Vlookup" in colume c and then convert whole raw c into values. otherwise if you send this file to someone else, it'll not work, if the link of workbook a is not accesseble to that person. "Gemi" wrote: I have two workbooks, one worksheet in each. Workbook one contains customer data A1:K362 Column C is blank and is where I need to enter the cutomers fgt acct numbers which are in workbook two. ColA ColB ColC ColD ColE Cust# FgtCarrier FgtAcct# CustName CustAdd Workbook two contains two columns A1:B570 ColA ColB Cust# FgtAcct# ColA from both worksheets contain the customer numbers, although not all customers are listed on the worksheet in workbook one. I need to fill in ColB with the fgt account numbers. Rather than manually going through both lists to match up customer acct. and then enter the corresponding fgt. number I am hoping there is another way. If the cust numbers in ColA match on both worksheets than enter the fgt acct number for the corresponding cust. acct (located in ColB on workbook2) in ColC on workbook 1. Thank you Lee |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging/Combining workbook data
On columm C workbook 1:
=vlookup(a2,[book2]Sheet1!$A$2:$b:570,2,0) replace [book2]sheet1! for the real names you are using; hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Gemi" escreveu: I have two workbooks, one worksheet in each. Workbook one contains customer data A1:K362 Column C is blank and is where I need to enter the cutomers fgt acct numbers which are in workbook two. ColA ColB ColC ColD ColE Cust# FgtCarrier FgtAcct# CustName CustAdd Workbook two contains two columns A1:B570 ColA ColB Cust# FgtAcct# ColA from both worksheets contain the customer numbers, although not all customers are listed on the worksheet in workbook one. I need to fill in ColB with the fgt account numbers. Rather than manually going through both lists to match up customer acct. and then enter the corresponding fgt. number I am hoping there is another way. If the cust numbers in ColA match on both worksheets than enter the fgt acct number for the corresponding cust. acct (located in ColB on workbook2) in ColC on workbook 1. Thank you Lee |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging/Combining workbook data
Thank you Marcelo,
I did the vlookup as suggested but got an invalid return. I copied the two columns from workbook two and pasted them on sheet two in workbook one. labeled fgt. Did vlookup in ColC sheet 1 =VLOOKUP(A2,fgt!A2:B570,2,0) recieved #N/A =VLOOKUP(A2,fgt!$A$2:$B570,2,0) received #N/A Any other suggestions? Thanks again for your help Lee "Marcelo" wrote: On columm C workbook 1: =vlookup(a2,[book2]Sheet1!$A$2:$b:570,2,0) replace [book2]sheet1! for the real names you are using; hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Gemi" escreveu: I have two workbooks, one worksheet in each. Workbook one contains customer data A1:K362 Column C is blank and is where I need to enter the cutomers fgt acct numbers which are in workbook two. ColA ColB ColC ColD ColE Cust# FgtCarrier FgtAcct# CustName CustAdd Workbook two contains two columns A1:B570 ColA ColB Cust# FgtAcct# ColA from both worksheets contain the customer numbers, although not all customers are listed on the worksheet in workbook one. I need to fill in ColB with the fgt account numbers. Rather than manually going through both lists to match up customer acct. and then enter the corresponding fgt. number I am hoping there is another way. If the cust numbers in ColA match on both worksheets than enter the fgt acct number for the corresponding cust. acct (located in ColB on workbook2) in ColC on workbook 1. Thank you Lee |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Merging/Combining workbook data
Marcelo,
I got it, =VLOOKUP(A2,fgt!A2:B570,2,0) Thank you so much for your help! This saved me hours of cross refrencing. Lee "Marcelo" wrote: On columm C workbook 1: =vlookup(a2,[book2]Sheet1!$A$2:$b:570,2,0) replace [book2]sheet1! for the real names you are using; hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Gemi" escreveu: I have two workbooks, one worksheet in each. Workbook one contains customer data A1:K362 Column C is blank and is where I need to enter the cutomers fgt acct numbers which are in workbook two. ColA ColB ColC ColD ColE Cust# FgtCarrier FgtAcct# CustName CustAdd Workbook two contains two columns A1:B570 ColA ColB Cust# FgtAcct# ColA from both worksheets contain the customer numbers, although not all customers are listed on the worksheet in workbook one. I need to fill in ColB with the fgt account numbers. Rather than manually going through both lists to match up customer acct. and then enter the corresponding fgt. number I am hoping there is another way. If the cust numbers in ColA match on both worksheets than enter the fgt acct number for the corresponding cust. acct (located in ColB on workbook2) in ColC on workbook 1. Thank you Lee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining and merging lines | Excel Discussion (Misc queries) | |||
shared workbook appending/merging rows of data from several worksh | Excel Discussion (Misc queries) | |||
Merging Workbook Data | Excel Discussion (Misc queries) | |||
Merging Workbook Table data Based upon Value comparisons | New Users to Excel | |||
Merging data in workbook | New Users to Excel |