Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 04-24-2011, 10:32 PM
udea udea is offline Lookup a value from non-sorted data Windows 7 64bit Lookup a value from non-sorted data Office 2007
Novice
Lookup a value from non-sorted data
 
Join Date: Apr 2011
Posts: 13
udea is on a distinguished road
Default

Mr. Macropod,

You are right, the value is 150.96515, but i just need the round up number. The matching logic to find the value is that the value should be below the peak.

from my point of view (for the data and the graph), the value i want occurred several times (before the peak or max and after that) and the formula i use will pick the later.

Is there anyway to limit the search up to the max value only, so that it will pick the value before the peak? The formula i want to write is general so that i can use it with any data i have.

Your effort is much appreciated.

Regards,
Udea
Reply With Quote
 



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:16 AM.


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