Get instant live expert help on I need help with vba cell address
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Hi, I have this formula: =ADDRESS(CELL("row",INDEX(Overview!A:A,MATCH($B$1,Overview!A:A,0))),CELL("col",INDEX(Overview!1:1,MATCH((INDIRECT(ADDRESS(ROW()-1,COLUMN()))),Overview!1:1,0))),1,0,"Overview"). The result is Overview!R4C3 which is correct but I want the value of that cell not the address. Can you help?
Solved by C. C. in 26 mins
Please help me understand the function. =IF(C$2+$A3<=60,SUM(INDIRECT(BM$2&ROW()&":"&CELL("address",OFFSET(C3,0,$A3-1)))),""). I don't get the SUM(INDIRECT(BM$2&ROW()&":"&CELL("address",OFFSET(C3,0,$A3-1)))) Part
Solved by G. F. in 18 mins
How to refer a Cell address derived from formula within another formula
Solved by V. J. in 23 mins
I am trying to fill a address field based off a previous entry. For example, cell A1 is an address code, ex MSP5. In A2 I want an address to fill based off the entry of MSP5
Solved by A. E. in 16 mins
I would like to find the address (location) of the cell with the same value as the original cells in column L and have the address in the column next to the original cell (column M).
Solved by B. H. in 16 mins