address function

  1. A

    Combining ADDRESS with an INDEX MATCH formula, to find cell reference

    Hi there, I currently have an INDEX MATCH formula which is working across 2 spreadsheets and returning the value of the cell I want it to, but I want it to return the reference of the cell instead of the value it contains. I keep getting different errors when I try to use the address...
  2. C

    Combine ADRESS and VLOOKUP

    I have a set of people that are forecasting their expected work completion similar to what i have listed below. You will notice in coumns H and I have a start date and end date. I actually have a few hundred rows in real life and based on various business events their start and end date may...
  3. P

    Chart using data range from address function

    Hi All, Nearing the end of my journey to create a Graph that updates itself based on if data exists. Background: I have 2 rows of finance over time. However only some of those cells have data. I have successfully used index and address functions to work out the address of where data starts and...
  4. E

    Creating range using addressed cells??

    Hi everyone, I am trying to set up a logic to identify the trends that should be copied into a different workbook. So far, I can identify where the trend is, but I am not able to set up the range, probably due to a variable definition. My attempt is to find the name I want (cll1) in w/s...
  5. F

    Still need help with address and matching function

    Hello Friends, Im using windows vista with excel 2007. I have a list of phone numbers in column C and the last four digits to those phone numbers in column B in descending order. Im looking for a function that would give me the address of my partial number in column B that is in column C? I...
  6. A

    Address Function Cell Reference Help

    Can anyone help me with adding to an address reference? I am trying to add a cell to an address reference. For example, the using the address function a cell returns the text $AH$11. I would like to subtract 3 to that reference so it becomes $AH$8. Ultimately, I will use a minimum function with...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top