I can't see your data, but I'm willing to bet you can do what you want to do
with a Pivot Table:
http://peltiertech.com/Excel/Pivots/pivottables.htm

http://www.contextures.com/tiptech.html
Look under P for Pivot Tables

Regards,
Ryan---


--
RyGuy


"Loyer" wrote:

Is there a simplier way of doing this. I have several of the same value to
look up and from there I wanted to find an additional value.

"ryguy7272" wrote:

This question seems to be coming up quite a bit lately:
http://www.contextures.com/xlFunctio...tml#IndexMatch

Either I see this question a lot or I try to apply the same solution to
different problems. I guess when you have a hammer in your hand, everything
looks like a nail!

Regards,
Ryan---
--
RyGuy


"Loyer" wrote:

Is there a way to look up a value from one cell to then take the result to
look up an additional cell? I would like to take the result of say :
VLOOKUP($A21,'BUYER GUIDE'!$A:$AO,2,FALSE) to then be able to look up an
additional value.

Thanks.