What formula should I use?

streetcat · #1 07-01-2015, 05:20 AM

Hi All,
I have two Sheets
In the first sheet, I have columns: Stock Name and Closing Price.
In the second sheet, I have columns: Stock Name and % of change.

What I want:

% of change (from Sheet2) should be displayed in the sheet 1 next to the closing price of the corresponding stock.
That is, Sheet 1 should have the following columns: Stock Name, Closing price and % of change.
I have attached spreadsheet for easy understanding.
Thanks for your support!
Cheers,
Streetcat

beginner · #2 07-01-2015, 07:37 AM

Quote:

Originally Posted by streetcat

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

streetcat · #3 07-01-2015, 11:07 PM

Thanks Beginner for the quick help.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula	Excel	Excel	1	08-14-2014 05:11 PM
Need help with formula	zachluke	Excel	3	03-13-2014 11:15 AM
Formula Help	clo312	Excel	11	01-11-2014 02:54 AM
Formula help	furface00	Excel	10	02-26-2012 05:34 AM
Formula Help - Look and if and that	Corca	Excel	2	02-05-2012 09:18 AM