Quote Originally Posted by deesh123
Your suggestion only pulls data from one cell; however, I need the sheet to be more dynamic since I have so much data.
Correctly entered it adds data from cells A6 and B6, both addresses of which were guesses as your examples give no indication as to which cells data is in.
I've thought about this long and hard and realized a simpler way to ask my question. Disregard my previous postings and see the following example:
Col A      Col B   Col C   Col D    Col E
                           Day No.  X
Day no.     1       2    | Today
Bench P    100     110   |  t
Leg P      200     210   |  s
I want my sheet to function so that when I replace "X" by typing a "1" then "t" and "s" are replaced by their values 100 and 200 for Day 1. Similarly, I when I replace "X" by typing a "2" I want "t" and "s" to be replaced by their values 110 and 210.

Is this possible in excel?
Many things are possible, and to be able to detect an entry in another cell and use that or some indicated data in a formula is reasonably standard practice.

However, without using VB code a cell will contain only the result of it's own formula.

For the cell containing t to react to you enterering a figure in a cell the formula must be aware of that cell, ie

=If(A1="x","",If(A1=2,200,100))

should fill your request.
---