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!