Thread: Excel newbie help - formula
View Single Post
 
Old 05-15-2014, 12:59 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default
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
Reply With Quote