VLookup in Excel 2003

[Loyer]

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.

 

[PCLIVE]

This is pretty simple if you just do your VLOOLUPs in two separate cells.
Once you have them working, then you can combine them.

Ex.
in A1 you have your first VLOOKUP formula.
=VLOOKUP($A21,'BUYER GUIDE'!$A:$AO,2,FALSE)

Then in A2, you perform another VLOOKUP using A1's result as the lookup
value
=VLOOKUP(A1,'BUYER GUIDE'!$A:$AO,2,FALSE)

You would then copy the entire formula in A1 and replace the A1 in your
second formula:
=VOOKUP(VLOOKUP($A21,'BUYER GUIDE'!$A:$AO,2,FALSE),'BUYER
GUIDE'!$A:$AO,2,FALSE)

HTH,
Paul

 

[ryguy7272]

This question seems to be coming up quite a bit lately:
http://www.contextures.com/xlFunctions03.html#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---

 

[Loyer]

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]

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---