What formula should I use?

		Microsoft Office Forums > Microsoft Excel > Excel
What formula should I use?

07-01-2015, 07:37 AM

beginner

Windows 7 32bit What formula should I use?

Office 2013

Advanced Beginner

Join Date: Sep 2011

Location: Europe

Posts: 45

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

Attached Files

Stock.xlsx (12.4 KB, 8 views)

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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:01 AM.