# Feeding values to cell ...

#### silmara

##### New Member
I don't really know how I could put this into words, so here it is ...

A1
B1 B2

X1 Y1 Z1
X2 Y2 Z2
Xn Yn Zn

Where all of the above are cells, and A1 is set equal to B1 and B2 (via a formula in A1 cell).

How would it be possible to do the followings in an automated way:

. Copy or feed X1 value to B1 and Y1 value to B2
. A1's result value then copied or fed to Z1
. So on for X2,Y2,Z2 up to Xn,Yn,Zn

In other words, I have a large fault tree, i.e. an arborescence with a single value on top (call a top event probability, A1 in this case) and various basic events at the bottom (only B1 and B2 in this example). In between there are various AND and OR gates. I want to feed values (called failure rates) to the basic events at the bottom and collect the results at the top to put this into a table (Z1, Z2 ... Zn).

Your help is appreciated ! Note that it is important for the above structure to remain intact (i.e. I can't simply put a formula in Z1 using B1 & B2 as parameters, the fault tree is very large and can not be translated into an equation).

Silmara

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.
I don't know about what you really intend doing, but, as far as your example is concerned, I did this:

First, Instead of using B1 and B2, I used cells B1 and C1. Then:
In cell A1, I entered the formula, =B1+C1
In cell B1, I entered the formula, =X1
In cell C1, I entered the formula, =Y1
In cells X1:X3, I entered 1, 2, 3
In cells Y1:Y3, I entered 11, 12, 13
In cell Z1, I entered the formula, =A1

Then, I copied down A1:C1 to A3:C3, and Z1 to Z3

I now have, in the range A1:C3:
12, 1. 11
14, 2, 12
16, 3, 13

And, in the range Z1:Z3:
12
14
16

Is this what you wanted? Let us know.

RalphA

Thank you RalphA but unfortunately that's not what I was thinking about. If I take back the example but as follow:

A1
A2 B2
A3 B3 C3
A4 B4 C4 D4
A5 B5 C5 D5 E5
etc ...

It is like a pyramid where I need to feed multiple number at the bottom and obtain a single number on top. The pyramid can be very large and complicated. I need to compile the top number as a function of bottom numbers in a table.

The problem is that I have thousands and thousands of numbers to feed to the pyramid. Cut'n Paste is not an option. And I can't represent the whole pyramid as a formula.

Thanks !

Silmara

By the way, I am a daily internet user and never seen a forum so far where there are so many posts ... Is it normal also that when you reply to a post, it does not goes back to the first position on the list as in other forums?

As to your problem: if you can post the rules to follow, I'm sure we can come up with a solution for you, but, the rules must be clear and not vary from post to post!

As to if it is "normal" for posts to be shown "first to last", as opposed to "last to first", I see them both ways. In one forum, you have the option of seeing them either way.

The rules did not change. There is no difference in showing a tree with only A1 B1 B2 (2 levels) and one that has multiple levels (5 in the last example). I am trying to show you different ways so that you understand the concept.

My question remains the same: how can I feed different sets of values at the base of the tree and collect the top result for each set ?

Any idea ?

Silmara

About the post ... I was not referring to options while you browse the posts. In other forums, if you reply to a post, it updates the time stamp of the post and puts it back as first seen in the list (since it is now considered as the latest).

Replies
12
Views
1K
Replies
17
Views
2K
Replies
1
Views
1K
Replies
1
Views
943
Replies
1
Views
502

1,203,111
Messages
6,053,571
Members
444,673
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back