Help! I have created a spreadsheet which is basically a formula sheet for taking wholesale items then adding profit/commission to it adding to it a per user multiplier(50 different multipliers in all) to come to a retail number. Currently I have the formula which works perfectly fine, but . The different products are listed on their own spreadsheet - so I have to go to that paper & get the product number and find the associated price for that product and manually enter it in my formula spreadsheet . Then I have to go to a different spread sheet to find the zip code for the user and the multiplier for that user and manually enter it in to my formula sheet. Is there any way I can design the "Formula" spreadsheet to access spreadsheet # 2 cell information and when I type in the user number the spreadsheet will automatically insert the correct multiplier?? The same with spreadsheet #3 simply type in the zip code and bingo.in comes the correct multiplier to my formula?? As you can tell I'm new to spreadsheets and computers in general, thanks in advance for your help and patience. Ed -- To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted