# Using the ADDRESS worksheet function

#### bearchaser

##### New Member
Can the cell address text string generated by the ADDRESS worksheet function be used as a reference for another calculation?

For example:
Could you use the ADDRESS worksheet function to define one end of a columnar SUM range? (Assuming all of the appropriate cells have numerical values.)

~Thanks

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.

or better:

=SUM(E2:INDEX(2:2,0,3))

By the way, these formulas involve a horizontal range.

Replies
3
Views
190
Replies
8
Views
287
Replies
3
Views
416
Replies
4
Views
132
Replies
2
Views
175

1,218,691
Messages
6,143,943
Members
450,516
Latest member
shironokuro

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

### Which adblocker are you using?

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