Forum Discussion
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))
In cell K11 of sheet 1 you can try
=VLOOKUP('Sheet 1'!$K$5,'Sheet 2'!$A$400:$B$403,2,FALSE)or
=INDEX('Sheet 2'!$B$400:$B$403,MATCH('Sheet 1'!$K$5,'Sheet 2'!$A$400:$A$403,0))
OliverScheurich also for completion i made a slight update to sheet2 where it pulls this data automatically from a google sheet
