Lookup a value from non-sorted data

		Microsoft Office Forums > Microsoft Excel > Excel
Lookup a value from non-sorted data

FAQ

Thread Tools

Display Modes

04-24-2011, 10:59 PM

macropod

Windows 7 32bit Lookup a value from non-sorted data

Office 2000

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,516

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]

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Multi-Variable Lookup help	ebolton	Excel	8	05-05-2011 05:28 AM
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
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 10:23 AM.