Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #8  
Old 04-24-2011, 10:59 PM
macropod's Avatar
macropod macropod is offline Lookup a value from non-sorted data Windows 7 32bit Lookup a value from non-sorted data Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,516
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi udea,

Matching works best with a exact number.

In D2 you can use the array formula (Ctrl-Shift-Enter):
=MAX(IF(A3:OFFSET(A3,MATCH(MAX(A3:A122),A3:A122,0)-1,0)<=MAX(A3:A122)/2,A3:OFFSET(A3,MATCH(MAX(A3:A122),A3:A122,0)-1,0)))
In E2 you can use the ordinary formula:
=INDEX(B3:B122,MATCH(D2,A3:A122,0))
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multi-Variable Lookup help ebolton Excel 8 05-05-2011 05:28 AM
Lookup a value from non-sorted data Field Lookup - Confused lawnG Word Tables 1 01-31-2011 03:50 PM
Creating Lookup in Excel vikash kumar Excel 2 12-06-2010 06:50 AM
Lookup a value from non-sorted data Using the LOOKUP Command Grapejuice Excel 2 10-15-2008 02:02 PM
Help with Max or lookup fomula to return a name forAmaxValue dutch4fire23 Excel 0 07-28-2006 01:12 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:11 PM.


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