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

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
You must log in or register to reply here.

Similar threads

N
  • Question Question
What should I do in order to solve an inconsistent reference error when using INDEX/MATCH?
Replies
1
Views
365
numbernoodle
N
P
  • Question 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
630
purekarting
P
E
  • Question Question
How to recognize text strings in INDEX-MATCH
Replies
5
Views
591
dfsobral
D
F
  • Question Question
Tie-Breaking Question (Using Index/Match/Large)
Replies
3
Views
952
Fluff
Fluff
E
  • Question Question
can't get INDEX-MATCH to copy entire column
Replies
2
Views
294
shift-del
shift-del

Forum statistics

Threads
1,224,603
Messages
6,179,850
Members
452,948
Latest member
UsmanAli786

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