Forum Discussion
Solved
Formula autofilling values present on another worksheet
Hello, need your kind help please with a formula that I'm trying to create linking cells in two worksheets and involving typing ticker symbols for stocks Sheet 1: Sheet 2: ...
You can adjust the source list of the data validation to:
=Sheet2!$A$396:$A$403
Row 396 isn't included in the provided formulas. The original example only included rows 400 to 403. However it's easy to adjust the formulas to a range that includes row 396.
=VLOOKUP(Sheet1!$K$5,Sheet2!$A$396:$B$403,2,FALSE)
=INDEX(Sheet2!$B$396:$B$403,MATCH(Sheet1!$K$5,Sheet2!$A$396:$A$403,0))
Does it work in the attached sample file? It works as intendend on my computer.
Hey i know where the problem is, but cant fix it! so it allows stocks only from rows 400 to 403, stocks like ENPH, ENVX but not other rows. i can even see it in the code however when i change it to 1 - 2000 for example it doesn't work?