Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup in Excel 2003
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup in Excel 2003
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup in Excel 2003
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup in Excel 2003
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup in Excel 2003
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 VLookup | Excel Discussion (Misc queries) | |||
Help with VLookup in Excel 2003 please | New Users to Excel | |||
Help with vlookup in Excel 2003 | Excel Worksheet Functions | |||
Help with VLookup in Excel 2003 please | Excel Worksheet Functions | |||
using a reference in vlookup with excel 2003 | Excel Worksheet Functions |