cell address

I have problems with the VLOOKUP, MATCH, INDEX and ADDRESS commands. I was hoping I could use these instead of a macro. This is what I want to do: I have 5 criteria with weights and assigned points. With this I get a result for the given alternative (sumproduct). Now my task is to show...

I'm trying to use a vlookup to return the cell reference on another sheet so I can use it in a formula. The other sheet is called sales. For some reason, I can get it to return Sales!A5 or =Sales!A5 but it doesn't count as a cell address for my other formula. It just treats it like text...

I have two tables on the same page; one is underneath the other. They are separate tables with separate headers. I am looking to find a value I computed in the Table A (the table on top) from Table B (the table below) and compare it to a new value computed in Table B and do something based on...

I need to display data in a cell based upon a scrolling counter. How do I split a cell address using the first Col Ref Letter like "BH" and append the counter to provide me with the row number which has been provided the data label of PCOUNT. Thanks, Michael

I have a simple max formula in Sheet1 that finds the max value from ranges of values in multiple other sheets. i.e. =MAX('Sheet 2'!A1:P44,'Sheet 3'!A1:P44,'Sheet 4'!A1:P44) I would like to show the location of that max value in the cell next to the value on Sheet 1, including both worksheet...

Hello, I am having difficulty finding a solution to make a range dynamic. I found my total row by using MATCH("Totals:",A2:A100,1)+1). Because I want to add addtional rows to the range (up to 100), I want to find the MIN of that range and I tried using this formula: MIN...

Hi Excel Gurus, Is there a way to retrieve the cell address using a lookup function? ie instead of retrieving the cell value I would like to retrieve the address of the cell.. Thanks in advance

Hello, I've been searching for a way to do this for a little while. What I am trying to do is during a loop operation, which subtotals variable ranges, I want to store the locations of the cells that it puts the sum function into. I.E. if based on criteria it determines that range E4:E12 is...

I was sent a spreadsheet that has a particular row where data is typed in one cell and appears in another. For example, if I type the word "No" in cell B11, it appears in cell O11. I have no merged cells in the spreadsheet.

How can you obtain the cell address of the cell being used in a "For Each Cell in Range("A1:A10") VBA statement (For Next code)?

Hi I am trying to insert text from cells in another worksheet as follows: I have a front sheet named "Front Sheet". Column A is already populated with a list of company names. Column B is for Contact names, Column C is for email address. Each company has its own worksheet, and is named as...

Hi all, I have a cell that has the string of a cell address in it say Cell A1 has the string B2 How can I in VBA look at this cell and use the text inside as a range the same as the INDRIECT function. Also can the cell I am looking at for the string be set as a Dim so if the contents change...

Can anyone please tell me how i can change the content of one cell in a fixed location without losing reference to the cell that triggered the worksheet_change (target) because once i change it i want to act with the cell that triggered or nearby with .offset when i try it my cell references...

Hey, Needed some help with nesting some formula. Suppose I have a row like this: <pre> A B C D E F 1 apple mango orange guava banana 2 2 4 1 5 5 </pre> a) Now, if I want to return the...

<table><tbody><tr><td class="votecell"> </td> <td class="postcell"> i have a cell (lets call it A1) which uses an if statement to determine its content. i.E...

I have a date column (C) and a series of columns that users add information into. Usually one row at a time. I've created a Worksheet Module that runs when the value in column (G) is updated (it changes the value in column C to equal Now()) Private Sub Worksheet_Change(ByVal areaOfInterest...

I have two worksheets. One has a list of account numbers, and sheet two needs to have nine itterations of that account number. While being extremely naive, I tried this: =Sheet2!$A$2$ (for the first nine iterations of the first account number) =Sheet2!$A(2+b1) (B was the column I was going...

I have a function checking if a certain value is present in a certain column how then do i get Excel to output which cell the value was found in?

Good day all, Just wondering if there's a way to print cell addresses using a macro? I have text that is being copied to a new worksheet from many work sheets into column A but I would like their cell locations to be printed into column B. Possible? Thanks, Adam

Hi everyone - I've seen a few posts on various forums with questions that initially seem similar to mine, but the given answer doesn't help me (e.g., here). I'm using XL2007 with Windows XP. Here's my issue: I have a table of values with a header row (the header row is a series of time points...