Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-04-2016, 12:45 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline workseet with Tables for VLOOKUP formulas needs to be split into 3 pages Windows 7 64bit workseet with Tables for VLOOKUP formulas needs to be split into 3 pages Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default


When you use the term " table" do you mean like a range ( some columns and rows without anything special) or is it a table that is inserted via the Insert ribbon in Excel?
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #2  
Old 10-04-2016, 07:37 AM
innkeeper9 innkeeper9 is offline workseet with Tables for VLOOKUP formulas needs to be split into 3 pages Windows 7 32bit workseet with Tables for VLOOKUP formulas needs to be split into 3 pages Office 2007
Novice
workseet with Tables for VLOOKUP formulas needs to be split into 3 pages
 
Join Date: Aug 2016
Posts: 20
innkeeper9 is on a distinguished road
Default

Hi. Yes, they are tables that I inserted from the Insert tab for the formulas like:

=IF(D26<>"",VLOOKUP(D26,Table6_Expense,2,FALSE),"" )

There are 9 of them, and they would split nicely into 3 groups if I could figure out how to do that, though I might learn more if I just played around with it

Ruth
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
workseet with Tables for VLOOKUP formulas needs to be split into 3 pages Formulas transferring to other pages in workbooks, but data isn't. Melissa Ames Excel 4 03-02-2016 01:58 PM
workseet with Tables for VLOOKUP formulas needs to be split into 3 pages Tables: Ensuring Rows Not Split Across Pages Yet Retaining Repeated Header Andrew H Word 5 12-28-2014 06:08 PM
Nested vlookup with varable tables! Dave Jones Excel 0 08-30-2012 09:15 AM
workseet with Tables for VLOOKUP formulas needs to be split into 3 pages Automatically split Mail Merge based on number of pages SaneMan Mail Merge 1 12-03-2011 01:11 AM
workseet with Tables for VLOOKUP formulas needs to be split into 3 pages Vlookup and If conditions together along with match formulas david_benjamin Excel 2 04-11-2011 11:30 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:24 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