Get instant live expert help on I need help with excel cell address

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Hello: 1st goal is to create an excel address list using addresses from mom's personal hard copy address book. 2nd goal is to print Avery address labels from the Excel list to put on postcards. okay, many of mom's addresses are couples with same last name. Question: How do I enter the two first names in one Excel cell so it ultimately prints on label as - example: George & Shelly Smith (for example).
Solved by O. U. in 30 mins
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
How to refer a Cell address derived from formula within another formula
Solved by V. J. in 23 mins
I need help to identify which ID'S in my excel sheet have different address or if the address match
Solved by C. C. in 18 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 S. U. in 22 mins