Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Matching last in a list Matching last in a list
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 06-08-2016, 12:13 PM
xor xor is offline Matching last in a list Windows 10 Matching last in a list 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
You could try:



=LOOKUP(2;1/(A1:A5="Bill");B1:B5)
Reply With Quote
  #2  
Old 06-08-2016, 01:30 PM
salse salse is offline Matching last in a list Windows 10 Matching last in a list Office 2016
Novice
Matching last in a list 		 
Join Date: Jun 2016
Posts: 3
salse is on a distinguished road
Default
I tried a few lookup functions like this before and although it worked, having each row search each other row seems to slow the sheet down so much, is there any other way?
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mis-matching merge fields BarbNH Mail Merge 8 01-09-2015 01:56 PM
Matching last in a list Record Matching Excel Excel 13 08-21-2014 09:44 PM
Matching last in a list Pge numbers on pages and in TOC not matching Marshalee Word 2 04-23-2014 10:40 AM
Matching last in a list Need help matching text to the Character Map Bobosmite Word 1 07-12-2012 08:12 AM
How to merge matching cells vertically? Odiseh Excel 1 01-02-2010 02:41 PM

Other Forums: Access Forums

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