Thread
: [Solved]
Lookup a value from non-sorted data
View Single Post
04-24-2011, 02:11 AM
macropod
Windows 7 32bit
Office 2000
Administrator
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
Hi Udea,
For a lookup value in D1, try:
=INDEX(B:B,MATCH(D1,A:A,0))
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Last edited by macropod; 04-24-2011 at
02:13 AM
. Reason: Added Match 'type' to ensure correct matching
macropod
View Public Profile
Find all posts by macropod