Can someone explain how this can be? The vba refs are different, yet once the vba pastes the functions,,, the references are identical!?!?
In other words, in the first paste into "C2", it refers to: C[-1]:C[1],3,0),
It appears the function is pin-pointing Col B and Col D by saying: C[-1]:C[1] (c minus 1 column = B) and (c plus 1 col = D)
When this function pastes itself into "C2" cell, it reflects a range of B:D (which sounds correct).
The 2nd paste into cell E2 has different references of: C[-3]:C[-1],3,0),
How can you go backwards 3 times from C? (c minus 1 is B, c minus 2 is a, what would c minus 3 mean?)
What I don't understand is: how can there be such a thing as [-3] when the start is C?
Someone shared this with me and I'm trying to understand the function so I can trouble shoot why its returning a "#N/A" value.
=============================================Please Login or Register to view this content.
The really mind blowing part to me is -- that once pasted, both come out to be "B:D" even though their references above were different with the C-1 and the C-3, etc..
Can anyone explain how this/why this is??
Once formula is pasted, C2 turns out being this:
=INDIRECT(CONCATENATE("PRODUCTION!",(LEFT(VLOOKUP(TODAY(),'RULE-Table'!B:D,3,0),FIND(",",VLOOKUP(TODAY(),'RULE-Table'!B:D,3,0),1)-1))))
and E2 turns out being this:
=INDIRECT(CONCATENATE("PRODUCTION!",(RIGHT(VLOOKUP(TODAY(),'RULE-Table'!B:D,3,0),LEN(VLOOKUP(TODAY(),'RULE-Table'!B:D,3,0))-FIND(",",VLOOKUP(TODAY(),'RULE-Table'!B:D,3,0),1)))))
Bookmarks