Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to use 2 worksheets in one formula with INDIRECT & VLOOKUP
I am trying to pull in information from two different worksheets into one
column, but some of the inofrmation from one sheet is different from the other, and some of the information is the same, and if it chages I want it to change automatically so right now I have this formula which does NOT work ---- =VLOOKUP(A5, INDIRECT("'"& $C$1 &" information'!$A$4:$L$97"; "'"& D1 &" information'!$A$4:$L$97"),12,FALSE)) ----- the C$1$ and D$1$ are references for 2005 and 2004 which would pull from those sheets, so if i change it to 2006 it will pull from the 2006 sheet automatically. Am i way off on the formula? Or is this even possible? If it is HOW? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Vlookup formula Excel version 2002 | Excel Discussion (Misc queries) | |||
IF / VLOOKUP formula won't work until saved | Excel Worksheet Functions | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
How do I use Range Names listed in a VLookup table in a formula? | Excel Worksheet Functions |