sheets in a formula
Posted by Tim on June 09, 2001 3:48 AM
Is it possible to creat a formula to do the folowing.
If sheet1 a1 = sheet2 a1 then enter amount from sheet3 c1 into sheet1 b1.
sheets 1 and 2 a1 contain text. if the text matches the enter an amount into sheet1 c1.
I have a list of product but cant get the prices to line up due to product missing or added .
most of the prices fit the product but about half way through items are missing or in different orders.
I have over 3000 items so I really need a formula.