Excel

Using lists in formulas?

I have a spreadsheet with 2000 products (column A) and A list of 50 different sales reps. One Sales Rep will be assigned to each product (column B). I would like to have the reps contact information automatically inserted in column C, D, & E. Is there some kind of formula that will allow me to...

Import data from Lotus notes into Openoffice

I've found many articles on the web of how to manipulate Open Office from the outside, but what I need is to manipulate the outside from within Open Office. We have some spreadsheets which have macros that connect to a Lotus Notes database using COM and we are looking into porting them over to...