Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Match multiple lookup values?
Register FAQ Mark Forums Read

Reply
 
Thread Tools Display Modes
  #1  
Old 06-09-2017, 11:50 PM
tinfanide tinfanide is offline Match multiple lookup values? Windows 7 64bit Match multiple lookup values? Office 2010 32bit
Expert
Match multiple lookup values? 		 
Join Date: Aug 2011
Posts: 312
tinfanide is on a distinguished road
Default Match multiple lookup values?
Book1.xlsx

I would like to get the last elective exam date per each student (cell in orange). I got stuck in the INDEX LARGE IF array formula and would like some help. Please see the attachment. Thanks!
Reply With Quote
  #2  
Old 06-11-2017, 09:08 PM
xor xor is offline Match multiple lookup values? Windows 10 Match multiple lookup values? Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,103
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
Is the attached what you want?
Attached Files
File Type: xlsx Student_2.xlsx (14.9 KB, 13 views)
Reply With Quote
  #3  
Old 06-15-2017, 12:10 AM
xor xor is offline Match multiple lookup values? Windows 10 Match multiple lookup values? Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,103
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
@tinfanide

Feeling a bit disillusioned that an expert like you apparently don't bother to respond.
Reply With Quote
  #4  
Old 07-02-2017, 05:35 AM
tinfanide tinfanide is offline Match multiple lookup values? Windows 7 64bit Match multiple lookup values? Office 2010 32bit
Expert
Match multiple lookup values? 		 
Join Date: Aug 2011
Posts: 312
tinfanide is on a distinguished road
Default
Quote:
Originally Posted by xor View Post
@tinfanide

Feeling a bit disillusioned that an expert like you apparently don't bother to respond.
Indeed. Busy work has kept me working out your formula from time to time. Up till now I'm still stuck at how MMULT works. That sounds overwhelming to me.
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
Match multiple lookup values? Trying to match values across multiple sheets coxyada Excel 2 12-13-2016 03:44 PM
Multiple found values from five sheets, multiple returned values in sheet six? irisha Excel Programming 26 09-30-2016 01:20 AM
Match multiple lookup values? using two lookup values to get a sum figur Ian A King Excel 3 05-18-2015 02:56 PM
Lookup multiple values and compare different scenarios to get a specific result mws Excel 5 05-24-2014 04:52 AM
How can match or lookup values from two separate tables? klawk26 Excel 1 07-31-2012 09:04 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:51 AM.

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