Cell to be activated, which is a result of a vlookup formula
could somebody please help me with some code for a macro?
I have following formula: =VLOOKUP($H6&"-"&I6,'Stock sheet'!$A:$F,6,FALSE)
After the result is displayed, I'd like the cursor to jump to that exact cell, which it found in 'Stock sheet'!$A:$F,6,False).
I tried Goto, but it doesn't work.