MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.

Posted by Aladin Akyurek on June 09, 2001 5:55 AM


In B1 on Sheet1 enter: =IF(A1=Sheet2!A1,Sheet3!C1,"")

This formula tests for an exact (case-insensitive) match. If you'd want to allow for a case-insentive partial match (e.g., 'zax' against 'zaxa'), a different formula is needed.

Unsure about the second part of your story: Is it related to the first part I just attempted to answer?



Posted by tim on June 10, 2001 5:09 AM


Thank you
You've just stoped me from throwing the computer against a wall.
One more qwestion, when I copy a formula into new cells or into the colum I have to double click on each cell to get the right values to come up. Why and how can this be avoided.
Thanks agin for your help!!!