Forum Discussion
Formula autofilling values present on another worksheet
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))
Perhaps the names of your sheets are "Sheet1" and "Sheet2" instead of "Sheet 1" and "Sheet 2". According to your first post i assumed the names are "Sheet 1" and "Sheet 2".
=VLOOKUP(Sheet1!$K$5,Sheet2!$A$400:$B$403,2,FALSE)=INDEX(Sheet2!$B$400:$B$403,MATCH(Sheet1!$K$5,Sheet2!$A$400:$A$403,0))These formulas should work. Otherwise you can adjust the sheetnames according to the actual names of your sheets.
Does it work in the attached sample file? It works as intendend on my computer.
- interesting... it does work on this file
- quick update, when i add a new ticker and price to your sample file say on row 396 on sheet 2, it doesn't reflect on sheet 1 (this value doesn't match data validations restrictions...
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))
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?
