1. 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...

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. 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. 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. 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. 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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back