assigning 2 values to a cell in excel

[rahulgumudavelly]

I have 2 sheets in an excel file, sheet-2 has the input and output coloumn's (inputs that are to be given in the sheet-1), whereas sheet-1 has the entire description of the various processes that take place in my company along with formulae to calculate the standard time of each process. suppose consider drilling process, input is "no. of holes to be drilled = 50 (suppose)" given in sheet-2, i get the time required to drill 50 holes in the output coloumn of sheet-2. problem is if the drilling activity is repeated can the same set of code in sheet-1 accept another input value and give the output along with the previous input? i.e. 2 inputs, 1 code, 2 outputs.can the cell in the code accept 2 input values giving me 2 output values??

[Henk Stander]

This might get you on the right track: http://www.dummies.com/how-to/conten...s-scenari.html

[rahulgumudavelly]

This might get you on the right track: http://www.dummies.com/how-to/conten...s-scenari.html

Thankyou for the suggestion