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

--

"Loyer" wrote in message
...
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.