Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to Extract Data from Spreadsheet
I use Windows XP and Excel 2003.
I have two rougly similar spreadsheets except one has more data fields than the other. Here's what I need to do. I need to look up an account number in spreadsheet 1, find the $ balance for that account number, then go to the spreadsheet 2, see if the account number from the first spreadsheet is populated or exists in spreadsheet number 2, and if so, populate the $ balance field in spreadsheet 2 from corresponding to teh same account number in spreadsheet 1. Does that make sense? Said another way, I'm looking for an account balance in spreadsheet 1, finding the corresponding account number in spreadsheet 2, populating an empty $ account balance in spreadsheet 2 from the account balance that exists in spreadsheet 1. I think this might involve a pivot table (?), but I have zero idea how to use this tool. I've looked in two Excel reference books and I'm not getting the hang of how to do this for my need. I'd appreciate your assistance and guidance. Thank you very much! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to Extract Data from Spreadsheet
I'd recommend using VLOOKUP.
Assume column B of Sheet1 has the account balances, column A of sheet 1 has the account numbers, and Sheet2 is constructed similarly. =VLOOKUP(A1,Sheet1!$A$1:$B$10,2,FALSE) would find the account number referenced in A1 of Sheet2, find the corresponding Account Number in Sheet1 and return its associated balance. Given the structure of the worksheets described above, this VLOOKUP formula would be entered in B1 Dave -- Brevity is the soul of wit. "heelfan" wrote: I use Windows XP and Excel 2003. I have two rougly similar spreadsheets except one has more data fields than the other. Here's what I need to do. I need to look up an account number in spreadsheet 1, find the $ balance for that account number, then go to the spreadsheet 2, see if the account number from the first spreadsheet is populated or exists in spreadsheet number 2, and if so, populate the $ balance field in spreadsheet 2 from corresponding to teh same account number in spreadsheet 1. Does that make sense? Said another way, I'm looking for an account balance in spreadsheet 1, finding the corresponding account number in spreadsheet 2, populating an empty $ account balance in spreadsheet 2 from the account balance that exists in spreadsheet 1. I think this might involve a pivot table (?), but I have zero idea how to use this tool. I've looked in two Excel reference books and I'm not getting the hang of how to do this for my need. I'd appreciate your assistance and guidance. Thank you very much! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
Two Questions: R1C1 and stop text number converting to data | Excel Discussion (Misc queries) | |||
Data Matching Button for MS Excel 2007 or later | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Sort pages? | Excel Discussion (Misc queries) |