Excel Lookups

		Microsoft Office Forums > Microsoft Excel > Excel
Excel Lookups

FAQ

Thread Tools

Display Modes

12-15-2017, 08:08 AM

NBVC

Windows 10 Excel Lookups

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
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 2007] Building Power Point Slides from data in an Excel Table	bremen22	Excel Programming	1	08-07-2013 11:01 AM
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 11:58 PM.