What formula should I use?
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
|