Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 02-19-2015, 12:00 PM
BlueSky BlueSky is offline Pivot table or Vlookup or how? Windows 7 64bit Pivot table or Vlookup or how? Office 2010 32bit
Novice
Pivot table or Vlookup or how?
 
Join Date: Feb 2015
Location: London
Posts: 9
BlueSky is on a distinguished road
Default

Okay I now have a working sheet. The right hand columns get the info they need from the columns A,B,C. But the right hand columns could contain 100 rows or more as could the data columns A,B,C. How do you generate the Vlookup statement automatically in columns I and J. If I have to type each statement in I might as well just type in the data from columns B and C. Should I be using a pivot table instead or is it something that needs VBA?
Attached Files
File Type: xlsx Test vlookup.xlsx (9.6 KB, 12 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Question- Can the table display in the order the boxes were checked/selected? blackjack Excel 0 09-13-2014 08:57 PM
Pivot table help TishyMouse Excel 2 04-27-2012 10:19 AM
Pivot table or Vlookup or how? pivot table aliasadi_07 Excel 1 03-11-2012 12:49 AM
Pivot table or Vlookup or how? Help with a pivot table please! natsha Excel 1 02-16-2012 12:41 PM
Pivot table or Vlookup or how? Pivot Table Karen615 Excel 5 08-03-2011 10:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:55 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft