Named ranges

normpam

Active Member
Joined
Oct 30, 2002
Messages
354
Very frustrating. I've created a named range, let's say 'Data' for the range A8:O300. I use 'data' in an Index/Match lookup and it works fine. Now, I need to use the same Index/Match formula on a different sheet. I realize that the named range stays, so to speak on the first sheet, and the formula will look up the information from that first sheet. But, if I delete the range name completely; then select the cells where the data is on the other sheet and name this new range 'Data', it should work, right? It doesn't. The formula still picks up the information from the original sheet where the range name was used.

Any ideas? thanks!
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
Found the issue.... there were two other named ranges I was using. had to delete them and rename as well....
 
Upvote 0

Forum statistics

Threads
1,213,561
Messages
6,114,312
Members
448,564
Latest member
ED38

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