Thread: What formula should I use?
View Single Post
 
Old 07-01-2015, 07:37 AM
beginner beginner is offline Windows 7 32bit Office 2013
Advanced Beginner
  
Join Date: Sep 2011
Location: Europe
Posts: 45
beginner will become famous soon enough
Default
Quote:
Originally Posted by streetcat View Post
That is, Sheet 1 should have the following columns: Stock Name, Closing price and % of change.
Try Vlookup or Index/Match functions
Code:
=VLOOKUP(A2;Sheet2!$A$2:$B$27;2;FALSE)
Code:
=INDEX(Sheet2!$B$2:$B$27;MATCH(A15;Sheet2!$A$2:$A$27;0))
see attach
Attached Files
File Type: xlsx Stock.xlsx (12.4 KB, 8 views)
Reply With Quote