Do you remember how you did it in Lotus? From what I have seen, though there are a few differences from spreadsheet application to spreadsheet application, for the most part, all spreadsheets have used the same core of functions. Likely, the functions you used for this in Lotus (such as VLOOKUP() or SUM(), etc.) are present in Excel as well.