Is there a place I can search previous discussions to see if this has
already been answered? Or can someone point me to the thread where
this was already answered?

I have a spreadsheet in the following format:

001 AAA 3.5
001 AAB 5.2
001 AAC 3.9
002 AAA 2.9
002 AAB 2.9
002 AAC 9.3
003 AAA 9.2
003 AAB 0.3
003 AAC 2.9


I want to sort it into something that looks like:

001
AAA 3.5
AAB 5.2
AAC 3.9

002
AAA 2.9

etc....

So I need something that will lookup 001, then look up AAA, and return
_that_ value. Is there anything that does that?

Alternatly, what I tried is to concatenate the first two columns, and
then lookup 001AAA. Unfortunatly, the vlookup function doesn't search
values, and I can't figure out how to get the text of that thing
without re-typing all of them. So is there a way to lookup the value
of a function, and return a value based on that?

Thanks,

Amanda


--
ahimel
------------------------------------------------------------------------
ahimel's Profile: http://www.excelforum.com/member.php...o&userid=23726
View this thread: http://www.excelforum.com/showthread...hreadid=374003