Microsoft Office Forums - View Single Post - [Solved] Pivot table or Vlookup or how?

Thread: [Solved] Pivot table or Vlookup or how?

View Single Post

Old

02-19-2015, 06:19 AM

gebobs

gebobs is offline

gebobs uses Windows 7 64bit

Windows 7 64bit gebobs uses Office 2010 64bit

gebobs uses Office 2010 64bit

Office 2010 64bit

Expert

Join Date: Mar 2014

Location: Atlanta

Posts: 837

gebobs has a spectacular aura about

gebobs has a spectacular aura about

Default

Yeah, a VLOOKUP will do that easily.

=VLOOKUP(objtable1, table2, 3, false)
=VLOOKUP(objtable1, table2, 4, false)

Reply With Quote