Search results for query: *

Hey guys, I am sorry, I left out a crucial part in my dilema....cell B1 is also an input cell....it displays selected list based on input in A1. The values 2 and 4 in arguements are just examples. I have drop down lists in B1 which will get displayed only if it satisfies the condition wrt value...

Hi Electricpete, If I write just a value in the 2nd and 3rd arguement, by default the formula will be set up for C1....which is not what I am looking to do. I want to write a formula for B1 in cell C1. So I dont know if I am on the correct path the way I am doing it. Do you see any alternative...

Hi All, I have a cell (say, A1) which receives input from user, a cell B1 which should compute/display a value based on the input in A1. If I write a condition or formula for this in B1, its gets over-written once I input a value in A1 and correspondingly B1 takes the desired value. So I cannot...

Thanks for the info Clyde38! I will try to reference it to some other cell. Joerd:I have already done all that, but you just confirmed that I am on the right track!Thanks!

Ok heres the thing...The input cells where I want the users to input/select values, have IF functions in them which would decide which options to display depending on some other cell. If I select that cell and say "allow user to modify" my IF condition is being wiped out and I dont get the...

Hi All, I am having a problem with cell modifications by users for my application in Excel 2000. I cannot protect my formulae in the cells without protecting the worksheet and protecting (locking,hiding) the cell itself and in that case, it then wouldnt let any user enter any value or even...

Thanks everyone!Concatenation and VLOOKUP worked like a charm! Morten, I will look into DOE for sure. Thanks!

Thanks Julian!I will try that out. Greg: you are right, my description is kinda vague! So here goes, I have 4 inter-related variables: material, process, coating, style (the 4 columns in the look up table) which influence my cost (the value which I am trying to get from the table). The data...

Hi, I am a new user of excel database functions and I need some help. For my application, I need to take 4 inputs from the front end, and get a value from the look up table. Can I use the vlookup formula for this?If yes, how can I use it for 4 conditions?I came across a lot of similar...