Referencing A Cell Reference That Is Already In A Cell.
Jun 1, 2007
I have a data set (A1:B4)
I have decided which cell I am interested in and have written it in cell (B8)... in my actual spreadsheet, this interest was calculated by a formula
Now I want cell B10 to display the information that I am interested in (ie: $100)... however, I want a formula to do this as my "cell of interests" will keep changing based on its predefine formula.
******** ******************** ************************************************************************>Microsoft Excel - Book8___Running: 11.0 : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutB10=
ABCD1DescriptionCost**2AAA100**3BBB200**4CCC300**5****6****7****8Cell*of*Interests:$B$2**9****10Formula*to*display*Cell*of*interests:***Database*
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
View 9 Replies
ADVERTISEMENT
Jan 8, 2012
How do I change a formula cell reference based on another cell's reference? I'm building a schedule that looks to a task's trigger and adds days based on that relationship. All entries in column "A" will be text and all cells in "B" will be the simple formula "=A2" or "=A3". Due date is calculated by adding the value in "C" to the preceding date in column "D". In the spreadsheet below, the trigger for "Budget set" is "Specs written" with 3 days added to the previous due date.
________A________________B_____________C_________D
1 Task___________Trigger_____________Days_____Due Date
2 Design begins__Proj OK______________10____10-Jan
3 Specs written__Design begins (A2)____5____15-Jan (D2+C3)
4 Budget set_____Specs written (A3)____3____18-Jan (D3+C4)
If the trigger for A4, "Budget set", changed from A3 to A2, is there a way that the formula that determines the due date in D4 could read the trigger cell reference in B4 so that the value in the corresponding row in column "C" is added in the date column?
View 4 Replies
View Related
Feb 12, 2014
we have a Excel 2010 worksheet containing multiple tables.
Table1
ColumnA ColumnB
1 Blue 12
2 Orange 14
15
11
3 Red 10
Table2
ColumnA ColumnB
1 Blue 11
2 Black 13
15
11
3 White 10
19
17
On a separate worksheet we want to calculate with the first worksheet's values.
For example: Calc1: Sum ColumnB IN Table1 WHERE ColumnA = Orange
How do we do such a calculation/formula?
View 4 Replies
View Related
Jul 10, 2014
Warhammer Quick Reference Desktop.xlsx
Its on book 2.
I'm trying to reference the Cryptek total that I got in the previous area, and put that result into the grand total army point formula. When I reference the solution cell, or even copy and paste the very same equation into it, and then proceed to filter the referenced cells change...
The obvious solution that i thought would work is write =D45 next to Cryptek in the point value column, then if I filter it SHOULD maintain the information from D45 except it doesn't.
View 11 Replies
View Related
Dec 12, 2012
i want to match a cell data with a range of cells and if matches return the cell reference in another cell
View 3 Replies
View Related
Jan 23, 2009
Right now cell B7 is referencing cell D3. However I want this to be dynamic in the sense that suppose I change the Phase 2 (which starts from ww3 (cell D3)) to ww5 (cell F3) then I would like that B7 should also get updated to F3 instead of D3.
Basically the Development phase of "Support" Project starts only when Phase 2 of "Project 1" starts.
ww = Work Week.
In short cell B7 should always be in sync with the ww of Phase 2 of Project 1.
View 3 Replies
View Related
Feb 5, 2013
In cell H1, I want to multiply the value in cell B[x] by $G$1 where x is given in cell A1. For example, if A1 is 4, I want to to multiply B4 by $G$1 and have the result in H1.
View 2 Replies
View Related
Feb 3, 2009
I'm trying to create a supply order form. Is it possible to enter a product name in one cell and have the price for that product automatically appear in another cell? Is there a formula that I can use to make this happen?
View 2 Replies
View Related
Apr 25, 2014
Let's say I've ended up with the number 8 in Cell D4 for example. Is there a formula that can return the letter "G" (The 8th Column) so I can use it in future cell references ? If so, let's say we store that in Cell B5. How do I now refer to a cell in a chosen Row of that same Column by reference to Cell B5 ? For example if I want to refer to Cell G33 can you refer to this Cell in some form like Cell(Contents of Cell B5;33) ??? Don't want to use R1C1 type references if possible.
View 9 Replies
View Related
Jun 19, 2008
I have 2 problems relating to LOOKUP.
Not sure if Excel can perform these calculations as they could get to complex.
Problem 1
Can it be possible to have excel look at data from one cell reference another cell then display the results from the cell next to it in another cell, sort of example:
Tab 1 (Never changes)
AB
Bob1
Jon2
Fred3
Tab 2 (Dynamic, changes each week)
AB
Jon
Fred
Bob
So it would work as follows.
Tab2 column B will take Tab2 column A’s data check Tab1 column A and display Tab1 column B’s result.
Problem 2
Weekly league rank table that shows position movements week by week
Example.
Week1
1Jon
2Bob
3Fred
Week2
1FredUp 2
2BobNot Moved
3JonDown 2
Can Excel calculate/show the actual movements of league positions?
View 9 Replies
View Related
Nov 3, 2011
If A1 is blank, able to edit and type in B1.
If A1 has text in it, B1 = C1
View 9 Replies
View Related
Sep 16, 2013
In excel, how do I set a reference cell and then have in the next cell, the reference cell + 12 rows below the reference cell? And, then in the following cell, 12 rows below the last cell, and so on. I have a guess that you would use the offset function, but I would like to be able to set the reference cell once and then have each cell following the reference cell to pull data from the sheet that the reference cell is on in increments of 12 rows below the reference cell. What is the excel code to do this?
View 9 Replies
View Related
Feb 8, 2012
Here is a formula I am trying to use to access another woorksheet to compare the values in J13 in each worksheet.
=IF(J13=INDIRECT("'"&$O$4&"'!"&"J13"),"â–¬",(IF(INDIRECT("'"&$O$4&"'!"&"J13")=" ","â–¬",(IF(J13=" ","â–¬",(IF(J13>INDIRECT("'"&$O$4&"'!"&"J13"),"â–¼","â–²")))))))
Where O4 contains the name of the first worksheet.
I want the formula reference [J13] to chage to J14, J15 and so on.
View 3 Replies
View Related
Nov 30, 2006
I'm dealing with a DDE link and have a cell that works when I type in the value =WINROS|AVEVOL!XOM . But I don't want to manually enter each value. So I have tried to use =INDIRECT("WINROS|AVEVOL!" & A2) where A2 contains the value 'XOM', but I get a #REF! error.
View 9 Replies
View Related
Mar 2, 2009
On the spreadsheet Im creating I am using cell referencing. The user will input data into the blank cells, and cell referencing will put them into another table. Then I add these using an IF(OR(ISBLANK formula.
However, the empty cells come through as 0's rather than a blank cell. As they're coming through as 0's, they're being calculated into the formula, and this is causing problems in my main table.
Is there a formula I can use to ensure that the empty cells being copied over do not give off any other value?
I tried to use a few different IF formulas to only let specific data go through, but it didn't work. I tried to have the blank cells produce a letter so that they wouldn't be calculted in the formula, but letters are also counted as measured values.
View 14 Replies
View Related
Jul 10, 2009
I have a row with month titles. I manually fill this with data as the year progresses. I need to automatically use the last month updated in the row in a formula. i.e. theformula is in one cell and calculates on the last figure in the row e,g, data is in january (say C3) - when I input Feb data in C4, I want the formula to automatically reference the last complete cell (ignore january data and calculate on Feb data), and so on through the year.
View 12 Replies
View Related
Jun 17, 2009
I'm trying to grab data from two sheets by first doing a match. The match works, but how can I now reference ws2 so that I can pick up data if this match is true?
View 2 Replies
View Related
Dec 14, 2009
I have a drop down list that references a few cells in another worksheet. When a value is chosen from the list, the adjacent cell give a description. Basically THe drop down is a list of clinic codes and the description gives time, day etc.
In order to do this, I have written modules as necessary for each drop down list like in the example below: .....
View 12 Replies
View Related
Nov 20, 2008
My current worksheet is being built for use in Eve-Online, a game I play. In specific, I am keeping track of profit made by manufacturing different items in the game. I am trying to build it like this:
Column 20 is a list of items, and the next 7 cells to the right of each item contain the mineral requirements for that item. So C20 says Bantam Frigate, C21-C28 will all contain numbers. Now, I am trying to create a function in the upper-right cells (like A1-A8) where if I type in "Bantam Frigate" into A1, A2-A8 will fetch the numbers that I put into C21-C28.
Now, I will be working with thousands of items, so I have to make sure I name both the 'database' and the query exactly right, but that's not a problem to me. Can I make something that will reference a value from (cell+1 column right) or (cell+2 columns right)
View 4 Replies
View Related
Apr 16, 2009
Say cell A1 has 55
Cell B1 has the formula =A1
Sort only column A (the 55 now becomes in a different row)
Cell B1 chnages value because it is referencing cell A1 which has now a new value.
I want cell B1 to ALWAYS get the value from that orginal cell (i.e. 55) no mmatter where that cell gets located after sorting.
INDIRECT, and Nammed Ranges don't seem to do it.
View 8 Replies
View Related
Apr 16, 2013
Here is what I have
1. Have a COUNT value in a cell (counted the number of rows with values in them).
2. A formula that needs this value (sums another set of values in another column that has the same number of rows).
Example: the COUNT value is 12, and is located in cell G5.
For simplicity sake I have a formula in cell I5 SUM(F1:F12).
Instead of directly referencing F12, I want the formula to be SUM(F1:F(G5)).
View 5 Replies
View Related
Apr 20, 2007
Formula that if the cell (C1) looks up C5, and the range in C5 is 1-10000, I want C1 to show 10, or if C5 has less than 1, then I want C5 to show 0.
View 9 Replies
View Related
Jul 25, 2006
I used to think I was moderately intelligent. Certainly, I thought I knew my way around a computer. Then I got the bright idea to try and learn VBA. Since then every attempt I've made in trying to produce the most basic of code results in mad fits of rage and me wanting to slit my wrists. I've read half a textbook and I keep trying to write simpler and simpler code to get some sort of result, just to give me the drive to carry on but no matter what I try it always goes completely wrong.
So before I stick me head through the computer screen, here is today's attempt. I want to select a worksheet. I then want to copy the contents of cell A2 down to A1200.
Private Sub CommandButton1_Click()
Sheets("Calls Outcome").Visible = True
Worksheets("Calls Outcome").Activate
Range("A2").Select
Selection.AutoFill Destination:=Range("A2:A1200")
End Sub
I’ve stepped through the code and I get an error on “Selection.AutoFill Destination:=Range("A2:A1200")”. After spending several eight-hour days trying to get something out of VBA I have zero energy and zero patience.
View 6 Replies
View Related
May 20, 2007
I have a cell on ' Sheet 2' with the following formula:
=MAX('Sheet1'!C3:'Sheet1'C10)
ie. it chooses the maximum value from column C between rows 3 and 10 on "Sheet 1".
Lets say the cell reference C10 is now entered into cell B1 on Sheet 2. How do I modify the above formula to reference B1?
I have tried INDIRECT function but can't get it to work.
View 5 Replies
View Related
Mar 11, 2009
I have a table that displays data from another worksheet. This is what the cell reference behind the table look like:
View 2 Replies
View Related
Feb 15, 2010
I have lets say 12 months of data. I have formulas that reference the latest 6 months. When I insert a new column to input a new month, how can I make the formulas include the new months without manually updating them.
EXAMPLE:
12 months of data exist in cells B3:M3 going from B3(oldest) to M3(newest). Formulas reference latest 6 months of data in cells H3:M3. When a new month hits, I insert a column after column M.I would like the formulas to now reference cells I3:N3 which is now the newest 6 months.
View 14 Replies
View Related
Jul 20, 2014
I have a workbook with 1000+ worksheets, all of which have 3-letter names. On a master sheet, I would like to make a query of how many non-empty cells there are on a subsidiary worksheet. This works:
Code:
=COUNTA(ABC!A:A)
What I'd like to do from time to time is input in column A a varying set of 3-letter worksheet names, say
AAB
ABC
CDE
And have a formula in column B that converts this to
=COUNTA(AAB!A:A)
=COUNTA(ABC!A:A)
=COUNTA(CDE!A:A)
I've learned that simply substituting the cell references A1, A2, A3 for AAB, ABC and CDE doesn't work. What do I need to do to achieve this?
View 2 Replies
View Related
Dec 2, 2009
I have a formula (AL15) to determine the address of the last column with a value greater than 1. =COUNTIF(C16:AC16,">=1")+2. I then use this column value to aquire the Absolute row "15" and the determined column=(ADDRESS(15,AL15,4)). This returns to me a Column value and row value that I need to use as a refference. How can I convert this returned value to a reference.
View 2 Replies
View Related
Feb 5, 2010
i am currently using the macro below to import text files into a spreadsheet. Currently, it begins the import in cell A1 which is what I recorded it to do. how do I change the code to begin the import on the active cell?
View 2 Replies
View Related
Feb 22, 2012
Cell C3 has "Joe"
Cell X44 is a VLOOKUP that retrieves "Joe"
Let's say Joe goes on vacation. The workbook user goes in and puts a blue fill in C3. Cell X44 would also need to change automatically.
What's needed to make this happen?
View 1 Replies
View Related
