Miriam:

Look at the statement "GL!SmartSheet101.sam" in the GL sample data. And especially look at the sheet labelled "Basic 4: Departmental Comparative". It's slightly more complex because it uses a range of Departments and the RNGMERGE function but the concept is the same. Note the way that the Account number in column B is defined.