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

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