Break "Link" using Xlookup to Index Match workbooks

S

Soren

New Member
Joined
Apr 25, 2006
Messages
39
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
I have a summary spreadsheet (containing 30 tabs, representing individual departments ) "linked" to 12 individual monthly spreadsheets, with similar tab names as summary spreadsheet, all "linked" together using Xlookup and Index Match formula.
I there a way (other than copying some 31000 formula cells as values manually, excluding local formula in the summary spreadsheet) to break this relationship?
Obviously using Index Match does not create a breakable link in Excel.
regards

Soren
 

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
You must log in or register to reply here.

Similar threads

P
  • Question
How to use a MATCH helper column containing rows from a different sheet and INDEX in an array formula to return based on data in the helper column?
Replies
0
Views
216
purekarting
P
E
  • Question
How to recognize text strings in INDEX-MATCH
Replies
5
Views
400
dfsobral
D
F
  • Question
Tie-Breaking Question (Using Index/Match/Large)
Replies
3
Views
387
Fluff
Fluff
E
  • Question
can't get INDEX-MATCH to copy entire column
Replies
2
Views
86
shift-del
shift-del
A
  • Question
Xlookup, Vlookup and/or VBA for finding, matching and inputting data to separate sheet
Replies
0
Views
558
AlfredDB
A

Forum statistics

Threads
1,215,766
Messages
6,126,758
Members
449,336
Latest member
p17tootie

Share this page

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top