Excel newbie help

		Microsoft Office Forums > Microsoft Excel > Excel
Excel newbie help - formula

FAQ

Thread Tools

Display Modes

05-15-2014, 12:59 AM

OTPM

Windows 7 32bit Excel newbie help - formula

Office 2010 32bit

Expert

Join Date: Apr 2011

Location: West Midlands

Posts: 981

Hi

Using your example:
Put this formula into B2 on Sheet 1 and copy down :
=VLOOKUP(A2,Sheet2!A:E,5,FALSE)
Put this formula ionto C2 on Sheet 1 and copy down:
=VLOOKUP(A2,Sheet2!A:E,3,FALSE)
Good luck
Tony

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
excel formula	jcaal50	Excel	6	05-16-2014 04:01 PM
Help with excel formula	GoldenSlumbers	Excel	2	12-13-2012 03:32 AM
Excel Formula	oRie	Excel	2	02-28-2012 07:48 PM
excel help Formula	sellspeed	Excel	15	03-10-2010 10:57 AM
Excel Formula Help	masoom84	Excel	1	03-07-2009 09:41 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:03 AM.