Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Excel Lookups Excel Lookups
Register FAQ Mark Forums Read

Reply
 
Thread Tools Display Modes
  #1  
Old 12-15-2017, 08:08 AM
NBVC's Avatar
NBVC NBVC is offline Excel Lookups Windows 10 Excel Lookups Office 2013
The Formula Guy
  
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default
Try:



=INDEX(Table3[[Apr-17]:[Grand Total]],MATCH($B$6,Table3[[Column2]:[Column2]],0)+ROWS(C$10:C10)-1,COLUMNS($C10:C10))

copied down and across the table
Reply With Quote
  #2  
Old 12-15-2017, 08:13 AM
paulmorton paulmorton is offline Excel Lookups Windows 10 Excel Lookups Office 2013
Novice
Excel Lookups 		 
Join Date: Dec 2017
Posts: 2
paulmorton is on a distinguished road
Default
Absolutely brilliant, thank you I would never have got that in a millions years, does just what I need.
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Hybrid Mode Hybrid Mode


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Lookups Maybe I need help with "Lookups"? garry05 Excel 3 02-10-2024 01:13 AM
Word & Excel 2010 - Best Options To Auto Insert MySQL & Excel Data? Hoser Word 1 03-17-2017 03:47 PM
LOOKUP - Complex lookup with 2 lookups in 1 cell sglandon Excel 6 05-05-2016 09:44 AM
Excel Lookups [Excel 2007] Building Power Point Slides from data in an Excel Table bremen22 Excel Programming 1 08-07-2013 11:01 AM
Excel Lookups Excel 2011 can't open old Excel 98 or Excel X files FLJohnson Excel 8 05-09-2012 11:26 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:08 PM.

Contact Us - Privacy Statement - Top

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