Thread: [Solved] Lookup a value from non-sorted data
View Single Post
 
Old 04-24-2011, 10:59 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2000
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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