Get instant live expert help on what is 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
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 have a spreadsheet in excel with a column with address, what do I have to do to click in the address and show me the map?
Solved by X. Q. in 24 mins
This is what i need to do. I need to import search data from a website. I have a list of addresses that I need to search for their actual owners name and address. When property address gets entered into the search on the website the information comes right up I need to have the owners name and address imported to my excel spread sheet.
Solved by G. Q. in 12 mins
I have a spreadsheet with information on thousands of contacts. Lots of information is mismatched such as phone number in the address column etc.. What is the best way to go about fixing this?
Solved by B. U. in 30 mins