Help NEEDED!

[g71gx]

I'm a first timer here. normally can find what I need by just searching but this one is stumping me.

I have 2 sheets in the same work book but I would like to move them to there own work book.

I'm trying to search column B in the NEW KITS sheet using a Name Manager in a separate work book.

I changed the formula from(Name Manager):

='NEW KITS'!B1953:B10000

To(Name Manager):

='\\AVXWHS2-PC\AVX Share\[Mikes Tracker.xlsx]NEW KITS'!B1953:B10000

but after i made the change I get a #VALUE! error.

any ideas? thanks!

 

[jamtay317]

try
=INDIRECT('\\AVXWHS2-PC\AVX Share\[Mikes Tracker.xlsx]NEW KITS'!B1953:B10000)

 

[Aladin Akyurek]

Try to reference the ranges of interest directly in the formulas you need to invoke.

 

[g71gx]

this did not work

try
=INDIRECT('\\AVXWHS2-PC\AVX Share\[Mikes Tracker.xlsx]NEW KITS'!B1953:B10000)

not understanding what you mean

Try to reference the ranges of interest directly in the formulas you need to invoke.

I also tried this

=C2-(COUNTIF('\\AVXWHS2-PC\AVX Share\[Mikes Tracker.xlsx]NEW KITS'!B1953:B10000,D10)*E10)-(COUNTIF('\\AVXWHS2-PC\AVX Share\[Mikes Tracker.xlsx]NEW KITS'!B1953:B10000,D12)*E12)-(COUNTIF('\\AVXWHS2-PC\AVX Share\[Mikes Tracker.xlsx]NEW KITS'!B1953:B10000,D14)*E14)-B2

 

[Aladin Akyurek]

this did not work


not understanding what you mean



I also tried this

=C2-(COUNTIF('\\AVXWHS2-PC\AVX Share\[Mikes Tracker.xlsx]NEW KITS'!B1953:B10000,D10)*E10)-(COUNTIF('\\AVXWHS2-PC\AVX Share\[Mikes Tracker.xlsx]NEW KITS'!B1953:B10000,D12)*E12)-(COUNTIF('\\AVXWHS2-PC\AVX Share\[Mikes Tracker.xlsx]NEW KITS'!B1953:B10000,D14)*E14)-B2

Don't use named ranges, use rather the ranges themselves in the formulas.

By the way, COUNTIF won't work with a closed workbook. Try to switch an array-processing formula like one with SumProduct...