Get instant live expert help on I need help with excel product function

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

=product(E69:(E67-E66)) was trying to use the product function to treat this formula while an error message came up
Solved by Z. W. in 19 mins
hello. i used a formula in a excel sheet using product and offset function but when transferred to another workbook is not working. could you help.
Solved by K. S. in 29 mins
I have product database from two sources in two separate excel sheets. I want to consolidate and validate only product name in these excel sheets into one consolidated excel product master.
Solved by O. Y. in 12 mins
I need to use my product inventory sheet and create a lookup function which will insert the retail price from my product pricing sheet. This way, if anything changes on the Product pricing sheet, the inventory sheet will be updated.
Solved by E. L. in 25 mins
my indirect function works but it returns a value error when I but the product function in front of it. (INDIRECT("'eVestment Data'!"&SUBSTITUTE(ADDRESS(1,((Y2-D3+1)*12+2),4),"1","")&ROW('eVestment Data'!A60)&":"&SUBSTITUTE(ADDRESS(1,MATCH($C3,'eVestment Data'!59:59,0),4),"1","")&60)) this formula works but as soon as i add product( 1+ Indirect...), it no longer works. Attached is the excel file
Solved by T. J. in 25 mins