Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- How to transfer a hyperlink from the cell a lookup formula locates in Excel
- I have a database in worksheet 2 in a Excel 2007 workbook. In worksheet 1, I have a combo box that lists the project numbers listed in the worksheet 2 database. As a person selects a project, several other cells in worksheet 1 are populated with the data, associated with...
- Tags: Storage, Microsoft Office, dan.pelch@..., cell, database, hyperlink, lookup formula, Microsoft Excel
- Discussion threads 2007-09-20
- Vlookup ~ formatng
- I make quite extensive use of Vlookup & Pivot tables. Sometimes I run into problems when the LOOKUP cell and the table are not formated i thinkthe same.To clarify, I get a 'n/a' response in the formula, but when i copy and and paste the lookup cell to the table...
- Tags: cell, lookup, lookup cell, lookup value, Rafiki, software, Value at Risk
- Q&A 2004-10-06
Additional Resources
- Won't remember linked file in excel
- I have a file that is linked to another file for lookup. All of a sudden everytime I open the file and add entries it opens a file open box looking for the linked file. Even if I already have the file open. I never had this...
- Tags: file-Open
- Q&A 2005-05-12
- Find a perfect match in a lookup table in Excel
- Using the FALSE argument in Excel can help you find a true match in a lookup table, while eliminating a lot of the confusion that is common with such comparisons. Mary Ann Richardson explains how to use the FALSE argument to your advantage. A lot of uses for a...
- Tags: Microsoft Excel, Microsoft Office, Mary Ann Richardson, VLOOKUP, exact match, Microsoft Office Suite Excel Tips Newsletter, Lookup, ID, Office Suites, Software
- Technical articles 2006-11-14
- Excel formula - copy cells from second worksheet
- Hi, I hope someone can help. I've got a workbook that contains a daily sales log, and the second sheet is a stock list with prices.In the sales log, Col. A is where the barcode data is entered (we've got that bit sorted) and Col. C is where the price...
- Tags: C/C++, Microsoft Excel, madison@..., cell, C
- Discussion threads 2007-11-01
- Creating a dropdown list that coresponds to different cells
- I would like to know how to create a drop down list for a specified set of values, I want these values to correspond to a different value for exampleRough Concrete corresponds to 0.8so when i select the name such as rough concrete the value 0.8 appears in a cell...
- Tags: Johnmotson@..., cell
- Discussion threads 2007-11-12
- Excel ANNOYANCES: Formula ANNOYANCES
- Transforming the data in the worksheets using formulas is what Excel does best. What could be annoying about that? Lots! Take one horrible example: consider what happens when one creates a formula in one cell and copy it to another cell. If one doesn't build the formula just right, the...
- Tags: Formula, Cell, Microsoft Excel, Microsoft Office, Office Suites, Software
- Book chapters 2004-12-08
- Formula not working always in excel suing VBA
- Hi alli've used a formula something likeactivesheet.cells(row,col).formula = "='C:Documents and SettingsAdministratorDesktop[sdfsdf.xls]Sheet1'!$A$12"this line will be in a loop , iterating for a couple of rows.But what is happening is, the formula works fine for most of the cells,but for a couple of a cells, ....instead of the result, the formula itself...
- Tags: redvamsi@..., Microsoft VBA, cell
- Discussion threads 2007-10-04
- Sum cells in as yet uncreated worksheets
- HelloI am trying to reproduce a formula I found in a locked worksheet. Copying and pasting formula has not worked.Formula is =sum('Day (0):end'!d16).The formula is designed to add values automatically when new sheets are added. If it helps am adding new sheets via a macro.Please help
- Tags: morrison_paul002@...
- Discussion threads 2007-07-24
- Easy lookup formulas in Excel
- Spend hours coming up with a complex formula, or let Excel work through the problem in a just a few minutes. by Susan Harkins
- Tags: Parameter, Cell, Microsoft Excel, Microsoft Office, Office Suites, Software, Susan Harkins
- Blog posts 2008-10-04
- EXCEL formula help
- I need to understand why excel is not allowing the same formula, that exists both above and below... I am only doing a sum of 7 cells on the same row? but if I enter the formula even with prens, or begin the formul with a 0, or even backward,...
- Tags: dawn.prentice@..., Microsoft Excel
- Discussion threads 2007-07-01
- iFD Formula (exe)
- iFD Formula is a compact powerful utility for Pocket PC that allows you to work with a sufficient set of formulas (mathematical, physical, and electrical). You can also add your own formulas where you can add new formula categories, new formulas and their parameter description. The calculation is easy and...
- Tags: Formula, Calculation, iFD Formula, Pocket PC, Handhelds, Operating Systems, Desktops, Hardware, Software
- Software downloads 2006-02-02
- A formula to return a formula in Excel???
- I have a situation in which several hundreds of sheets in the same workbook require the same formula to be enterred. Is there a way short of building a function that I can enter the formula once in a 'Legend' sheet, and then use a reference to that cell in...
- Tags: bubba_barnett@..., Cell, Cell A1, Sheet1
- Discussion threads 2007-04-24
- Excel Formula that doesn't repeat when you use drag and fill
- I'd like to create a formula for a spreadsheet and populate all the line items without having the formula repeat over and over. Someone did it in one of their spreadsheets but would not share how he did it.Thanks,SusanI'm not sure what you mean.Do you want to copy the...
- Tags: PRODUCTIVITY, Microsoft Excel, smdonahue@...
- Discussion threads 2007-06-22
- Formula dragging in excel
- I was just wondering, when you drag a formuladown the page, is it possible to drag only the formula and not the cell format. eg. if there is a formula in a cell which has a border, can you drag the formula to other cells without dragging the cells border??
- Tags: nickl@..., cell
- Discussion threads 2007-08-01
- Do not update formula when inserting rows in Excel
- In Excel, I want to be able to insert a row but NOT update a formula referencing that row. For example in Cell B1 I have the formula =AVERAGE(B3:B33) now when I insert a new row at row 3 the formula automatically changes to =AVERAGE(B4:B34) I want to ALWAYS average...
- Tags: 7s1u7le79ba7089@..., Microsoft Excel
- Discussion threads 2007-05-03
- Vlookup
- Hi, i'm a student struggling with Vlookup i need a really slow step by step indepth instruction on how to use this function. I'm trying to return values such as customer name,code and so on (i have offered half the points i have because i am weary from searching the...
- Tags: VLOOKUP, lookup
- Q&A 2005-10-12
- Formulas in Excel
- I have created a formula in Excel as below: =SUM(IF(Data1!B1:B155=B9, IF(Data1!C1:C155=AD10,IF(Data1!I1:I155 = 2, Data1!L1:L153,0),0),0))But it is not displaying the result in the cell. If i am in the formula and do a F9 Calculate it will bring the correct result through but will make the formula disapear. How can i...
- Tags: feedback, Microsoft Excel, off-topic, simon_sez_it@...
- Discussion threads 2007-01-11
- Copy an Excel formula without changing its cell references
- After having written the formula for instance like=A1*B1/D1To achieve the result of copying and pasting so that the cell references do not change all you need to do is to modify the formula like this=$A$1*$B$1/$D$1now the cell references are ab
- Tags: ASAP Utilities, cell, cell reference, feedback, gbramley@..., Microsoft Excel
- Discussion threads 2006-11-01
- Formula 1 RSS Feed (widget)
- As requested by a Uni friend of mine, I've devised a widget displaying news about Formula 1. Follows the same layout as my previous widgets, and the same credits apply. Formula 1 RSS Feed are proving more popular than expected. This version is the first release on CNET Download.com.
- Tags: RSS Feed, RSS, Internet
- Software downloads 2007-07-23
- << Previous
- page 1 of 1
- Next >>
