Conditional Statement With a Series

  • Thread starter Thread starter znrd40
  • Start date Start date
Z

znrd40

I am having trouble thinking of a simple way to accomplish my task an
am wondering if anyone can suggest either a way to do it with Exce
formulas or if they think it looks like I will need to write a macr
for the job.

Here is my curent formula:
=If(AND(B1=B2, B2=B3), Sheet1!A41, Sheet2!A42

Basically I have two columns, one column is a list of objects and th
other column is a unique idea number that groups the list of object
(specificaly a list of ingredients for a recipe). I would like t
insert a third column that based on the ID number lists the recip
name. (I know this is best done in a database, but I'm tryign t
create a file for people without database programs or skills.)

So I want it to look something like this:

ID Title Ingredients
1 coffe
 
Sorry, cut myself off. I want it to look like this:

ID Title Ingredient
1 coffee water
1 coffee coffee
2 soda ice
2 soda coke

So I have the ID column and the ingredient column, but if I try and us
the automatic fill, then Excel changes A41 to A42 in the next row down
If I include the $ then I can get the first two recipes to fill i
fine, but as soon as I get to the third, the $ messes it up.


So, is there a middle ground between changing each row and having n
change at all?

thanks
mary bet
 
Back
Top