Please help, I am trying to link excel data to mappoint, when mappoint ask's me to choose the sheet or range I want to map, I click on the named range but I get told there was a problem opening it. In excel the sheet I want to link to is called Qty Households, Mappoint describe's it as a named range called Qty Households!_
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Named range linking with MapPoint
- Thread starter ian chubb
- Start date
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.
Similar threads
- Solved
- Replies
- 5
- Views
- 136
- Replies
- 2
- Views
- 256
- Solved
- Replies
- 2
- Views
- 435
- Replies
- 2
- Views
- 102
