Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jinx2311

    assigning a function to a cell remotely

    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...
  2. jinx2311

    assigning a function to a cell remotely

    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...
  3. jinx2311

    assigning a function to a cell remotely

    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...
  4. jinx2311

    Formula Protection while allowing users to modify value in cells?

    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!
  5. jinx2311

    Formula Protection while allowing users to modify value in cells?

    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...
  6. jinx2311

    Formula Protection while allowing users to modify value in cells?

    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...
  7. jinx2311

    Need help on Vlookup for 4 conditions

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

    Need help on Vlookup for 4 conditions

    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...
  9. jinx2311

    Need help on Vlookup for 4 conditions

    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...

Part and Inventory Search

Back
Top