Thread: [Solved] Pivot table or Vlookup or how?
View Single Post
 
Old 02-19-2015, 08:02 AM
BlueSky BlueSky is offline Windows 7 64bit Office 2010 32bit
Novice
  
Join Date: Feb 2015
Location: London
Posts: 9
BlueSky is on a distinguished road
Default
Quote:
Originally Posted by gebobs View Post
Yeah, a VLOOKUP will do that easily.

=VLOOKUP(objtable1, table2, 3, false)
=VLOOKUP(objtable1, table2, 4, false)
Wow I will have to try that do both data sets have to be in the same workbook on different sheets or can you link to a different workbook? I'm not sure about that side of things. Thank you for your input at least now I know it can be done.
Reply With Quote