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!
-
Congratulations MintJulep on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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...- jinx2311
- Thread
- Replies: 6
- Forum: -Engineering spreadsheets
-
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...- jinx2311
- Thread
- Replies: 7
- Forum: -Engineering spreadsheets
-
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...- jinx2311
- Thread
- Replies: 8
- Forum: -Engineering spreadsheets
