=vlookup(c2,code1,2,false) I am using the vlookup code but I would like to use the cell value in \'c2\' rather than c2 itself. The value within this cell will change, at the moment it is \'aj2\'. Is
开发者_Python百科In Excel, how can I set up a spreadsheet so when I type in one cell it will populate another cell in the same spreadsheet?I\'ll field this one.
I have 3 ranges of numbers and the answer depends on the range. 75-79 -> 0.255 80-84 -> 0.327 85+-> 0.559
Here is my dilemma. I have two worksheets one that has the name of clients and one that i want to copy the names to depending on the city.
How do you sum a variable range of cells based upon today\'s date in MS Excel 2003. Spreadsheet format:
I\'m very new to Excel and VBA and was wondering if there is a way I could make conditional formatting based on values in a drop down list (created from data validation).
Image describing the problem http://img215.imageshack.us/img215/3725/20100314235127schedule2.jpg I hope the image above can explain what I need. :)
The data in TheRange is {1,\"\",1,\"\",1,\"\",1,\"\",2}. =Match(2, TheRange, 1) returns 9 as expected.
In Excel 2007, I want the differences for the following string date/times: 开发者_高级运维 ABC 1 Date1Date2Difference of A and B
加载中,请稍侯......